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;
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center