Toad World Issues

Toad World Community

NOTE: This forum is for questions and discussions concerning the Toad World website and not for products/platform.
 
Please post product/platform questions in their respective forums.  Thanks!

Community Discussion

bgorilla
Follow / 23 Apr 2015 at 4:55pm / Toad World
Latest post by on 23 Apr 2015 at 9:25pm

Creating Scheduler Job

Expand content
Hello, Hopefully I'm in the correct forum for this question. I'm trying to create a Scheduled Job in Toad 10.6.1.3 which executes a stored procedure. The procedure is simple and runs fine manually...

Hello,

Hopefully I'm in the correct forum for this question. I'm trying to create a Scheduled Job in Toad 10.6.1.3 which executes a stored procedure. The procedure is simple and runs fine manually. I'm having real difficulty creating the scheduled job that would spawn it. It seems I can't get the Start Date in the correct format. I've tried many things...SYSDATE, SYSTIMESTAMP along with various other hard dates but I'm getting different errors for each. For example: using SYSDATE as the Start Date I get..."ORA-01841: (full) year must be between -4713 and +9999, and not be 0 ORA-06512: at line 2"
I've searched in this forum along with on the internet but haven't found anything that really helps. Can someone please assist?

Thanks

18 1 / Create an account to join the discussion.
shashikant
Follow / 22 Apr 2015 at 8:27am / Toad World

Directory Invalid Error

Expand content
Hi, I am new to Toad for Data Analysts. I am creating on automated toad script using Toad for Data Analysts.I have created .tas file using Toad for Data Analysts. For achieving this i have written...

Hi,

I am new to Toad for Data Analysts.

I am creating on automated toad script using Toad for Data Analysts.I have created .tas file  using Toad for Data Analysts.

For achieving this i have written one sql query which is located on my local machine.Then I am exporting  sql query output in excel file on same machine.I have given export excel location to the task.

Now my problem is when i am running this tas on Toad for Data Analysts it is giving me below error message.

  at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
--   at System.IO.__Error.WinIOError()
--   at System.IO.Path.GetTempFileName()
--   at Quest.Toad.ImportExport.ExportEngine.InitLogging()
--   at Quest.Toad.ImportExport.ExportEngine..ctor(String wizardXml, Boolean log)
--   at Quest.Toad.Workflow.Activities.Database.SelectToExcelActivity.Execute(ActivityExecutionContext executionContext)

 

 

 

 

21 0 / Create an account to join the discussion.
Rafael.Canseco
Follow / 22 Apr 2015 at 4:05am / Toad World

Loading Procedures/Packages... - Eternally!!! :|

Expand content
Hi, I have a problem: when I try to make a DB conection take a lot of time to load Procedures, Packages, triggers, synonyms, etc. and when finally finish to load all thouse components is very slowly the...

Hi, I have a problem: when I try to make a DB conection take a lot of time to load Procedures, Packages, triggers, synonyms, etc. and when finally finish to load all thouse components is very slowly the app... Before update it didn't happen. Coul you tell me what can I do? Please!!!

10 0 / Create an account to join the discussion.
Harpalsgh
Follow / 20 Apr 2015 at 3:23am / Toad World

TFS source control in Toad

Expand content
I have configured TFS as source control in toad, It is working fine for few users but for all other users local files are getting deleted on checkout. Please help

I have configured TFS as source control in toad, It is working fine for few users but for all other users local files are getting deleted on checkout.

Please help

16 0 / Create an account to join the discussion.
lukeVM
Follow / 6 Mar 2015 at 11:02am / Toad World
Latest post by on 6 Apr 2015 at 4:29pm

more than one file attachment

Expand content
Hi it would be nice to have the possibilty to attach more than one file to a post for example to post the slq code and also the error report. Other idea: possibilty collapse and expand textparts in...

Hi

it would be nice to have the possibilty to attach more than one file to a post for example to post the slq code and also the error report.

Other idea: possibilty collapse and expand textparts in the post (special tag for long textparts like error report)

At the moment you need to scroll over all text from the error report to see the next posting.

Lucas

107 1 / Create an account to join the discussion.