Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12801: error signaled in parallel query server P000 (Oracle,10.2.4.0,linux)
ORA-12801: error signaled in parallel query server P000 [message #422640] Fri, 18 September 2009 01:06 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

i am getting below error while searching the data from screen.

error:
ORA-12801: error signaled in parallel query server P000
ORA-01008: not all variables bound

but 1st time search: it shows the error in sql trace file.
2nd time search: it shows the correct output in screen.

i have checked the backend query whether all input comes correct or not. The all input values correctly matched with input variables. the query gives output in database. the problem occur only when searching data from screen. it occur only production system.

the same environment and same level of data are present in Local QA environment.but we could not reproduce the error in QA environment.

Please give the solutions about it. is any oracle bug there.
Re: ORA-12801: error signaled in parallel query server P000 [message #422644 is a reply to message #422640] Fri, 18 September 2009 01:27 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A trace file was generated, have a look at it.

Regards
Michel
Previous Topic: Getting Financial Year Begining
Next Topic: procedure in select
Goto Forum:
  


Current Time: Mon Dec 05 21:21:46 CST 2016

Total time taken to generate the page: 0.24532 seconds