Return
-
Title
Automation produces Oracle error ORA-00907: missing right parenthesis -
Description
Trying to create a simple automation that consists of just settings and an Export task. The input query is a locally stored .sql file, which runs fine when opened directly, and I also tried pasting the SQL directly into the window. The output is DelimitedText. When run the automation, get this error:
Automation Logging:5/24/2016 5:43:09 PM: Export_1 - ORA-00907: missing right parenthesis
-
Resolution
The SQL has several comments of both styles (/* */ --) (Script)Looks like is erroring on one of these comments. We recently made a change for nested comments. So you can try one of the following options.a) Download and try the 4.0 Beta to see if the prior fix we made applies to this issue.http://www.toadworld.com/products/toad-data-point/toad_data_point_beta_program-or-b) Take out all of the comments in the SQL-or-c) Turn on verbose logging, generate the error and send back the full log file, tas file and all dependent files. Also open script in editor, execute and then generate support bundle. This will create DDL so I can use the exact SQL and see where the error is occurring.http://supportadmin.prod.quest.corp/KBViewer/get/1-SZSVXB