ORA-12801: error signaled in parallel query server P014

[Altavista]

Hi,
Oracle Version : 8.1.7.0
I am executing a PL/SQL package which has a query
having Union of Two Select Queries.
One of the Select queries has a To_DATE(Null) in it.

The Query when run seperately outside the package works
fine but within the Package it fails.

Strangely for the same data set it sometimes executes
and sometimes fails. This is the most intriguing part.

The Parallel Query Servor error numbers are also
different P014,P019,P022,P013

I would greatly appreciate if anyone could help me
resolve this mystery.

 

[rcurva]

Could you give all the errors in the error stack bec ORA-12801 is a generic error pertaining to OPS?
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[Altavista]

Thanks very much for giving your valuable time into
looking at the Query.


The following are the ERROR Stack Messages

ORA-12801: error signaled in parallel query server P014
ORA-01790: expression must have same datatype as corresponding expression
ORA-06512: at "ORACLE PACKAGE NAME.STORED PROC NAME", line 4492
ORA-06512: at line 1

Let me know if this information is sufficient..or you
need anything more.
This is becoming critical day by day.

 

[rcurva]

Based on the Metalink, it is a bug (1553432). There are workarounds though,

- set PQ=1 or No Parallel
- CAST function is used instead of TO_DATE.
- not change NLS_DATE_FORMAT

How about changing TO_DATE(null) into sysdate + null?


Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War