ORA-12801: error signaled in parallel query server P000 [message #422640] |
Fri, 18 September 2009 01:06  |
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.
|
|
|
|