The following week I had a look at the alert log. I was greeted with ORA-00600 messages.
ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [78402], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [78402]
Later on that day the users complained about their sessions dying when executing a certain package call from the web front end.
On metalink I found a bug note resembling the error which effects versions of Oracle < 11.2, starting at version 10.2.0.3.
Bug 6068126
I opened up an SR with Oracle, shortly after they responded with a reference to Bug 13612575 (comes with a test case to reproduce the error)
It seems as if the bug was reintroduced in 11.2.0.3, though it comes in a different form, the conditions of its occurrence remain.
Both of these bugs surround the poor handling of REF CURSORs. Read the solutions in either of the bug notes to work around the problem.
The workaround suggested by the note was implement, and since then the alert log has been clear of errors.
Cheers
No comments:
Post a Comment