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

aymanzone
Follow / 21 May 2015 at 2:46am / Toad World

Where to find the Toak Schema used in the free lessons?

Expand content
Hi, where can I find the script to create Toad Schema used by the free courses which I am following? Is there a link/doc for finding more info on Toad Schema? I have Toad for Oracle Professional...

Hi,

where can I find the script to create Toad Schema used by the free courses which I am following?

Is there a link/doc for finding more info on Toad Schema?

 

I have Toad for Oracle Professional but I'm not able to post there even after joining.

 

I send email to admin about this, as per FAQ advice. However, this is the only place I can post for now.

 

Oracle 11.2.0.4, windows 7 enterprise service pack 1, toad 12.6

 

Thank you 

11 0 / Create an account to join the discussion.
jhaustein
Follow / 20 May 2015 at 8:28am / Toad World

mysql database error

Expand content
hi i try to create an connection to my database with toad to my provider now i get this error message Der angeforderte Name ist gültig, es wurden jedoch keine Daten des angeforderten Typs...

hi

i try to create an connection to my database with toad to my provider

now i get this error message

Der angeforderte Name ist gültig, es wurden jedoch keine Daten des angeforderten Typs gefunden

19 0 / Create an account to join the discussion.
parthipanmurali
Follow / 5 May 2015 at 6:49am / Toad World

INSERT IN ORACLE

Expand content
i need one insert query in oracle but it will insert multiple row in table. please help me to do the scenario ...

i need one insert query in oracle but it will insert multiple row in table.

please help me to do the scenario ...

46 0 / Create an account to join the 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

71 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)

 

 

 

 

76 0 / Create an account to join the discussion.