I am calling a packaged procedure in an external database from a PL/SQL 2.3 program. Occasionally the program crashes when calling the package, giving error ORA-03117: TWO-TASK SAVE AREA OVERFLOW. I cannot seem to trap this error with an exception handler and apparently the same data works fine when run on the remote database.
Does anyone have any ideas, I've tried everything I can think of.
do you have a "WHEN OTHERS" clause in your exception block?
Yes, I have tried trapping the exception explicitly using the error code and also using a 'WHEN OTHERS' clause - both appear to have no effect.
The actual error text says
ORA-03117 two-task save area overflow
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Customer Support.
I suppose if nobody else has a suggestion, open up a tar and see what support has to say about it.
Click Here to Expand Forum to Full Width