Gets the error below when running or executing a query statement using F9 or F5. Is SQL Plus, the query runs fine.
"ORA-24450: Cannot pre-process OCI statement"
Example SQL Query:
select concurrent_queue_name "QUEUE NAME", user_CONCURRENT_PROGRAM_NAME "PROGRAM NAME", priority,decode(phase_code,'P','Pending','R','Running') "PHASE", decode(status_code,'A','Waiting','B','Resuming','C','Normal','D','Cancelled','E','Error','F', 'Scheduled','G','Warning','H','On Hold','I','Normal','M','No Manager','Q','Standby','R','Normal','S', 'Suspended','T','Terminating','U','Disabled','W','Paused','X','Terminated','Z','Waiting') " Status", status_code,count(*) from fnd_concurrent_worker_requests where phase_code in ('P','R') and hold_flag!='Y' and requested_start_date<=sysdate and concurrent_queue_name<> 'FNDCRM' group by concurrent_queue_name, user_CONCURRENT_PROGRAM_NAME, priority,phase_code,status_code order by concurrent_queue_name desc, count(*) desc;
The issue is there is a line feed after the double quotes.
Example:
"
Status"
Avoid putting a line feed inside your double-quotes. The TFO 13.1 Beta is able to handle this with no errors. The next release of Toad will also be able to handle it with no errors.
If you would like to download and try the Beta, you can download it from here:
https://forums.toadworld.com/t/toad-for-oracle-13-1-beta/41283
NOTE: Toad Support does not provide support for Beta. To get support on the Beta, please visit the Toad World Forum and post your questions there.
© ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center