This content has been marked as final. Show 2 replies
I haven't seen this before, and not sure what could be causing it. You'll need to get a stack trace so the exact location of the error can be identified.
SQL> alter session set events '06531 trace name errorstack level 1, forever';
It seems the RCA has been found.
We have a trigger in one of the OWM tables, which has invoked a package who has a global collection not initialized. Having that piece of code fixed, this exception is not happening any more.
When debugging the code, I traced to the exception in WMSYS codes that invoked this trigger.
As to why sometimes it happens and the other time does not, that's because in that package containing the global collection, one of its procedure initialized this collection. Therefore, we may happened to invoked that API and got collection initialized. This is totally a code issue in our side.
Edited by: user5736610 on 2011-4-14 下午7:03