ORA-03117 - Why can't I trap this error??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-03117 - Why can't I trap this error??

  1. #1
    Join Date
    Nov 2000
    Posts
    2

    Unhappy

    Hi,

    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.

    Thanks,
    George.

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    do you have a "WHEN OTHERS" clause in your exception block?

  3. #3
    Join Date
    Nov 2000
    Posts
    2

    Thumbs down error trapping

    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.

  4. #4
    Join Date
    Jun 2000
    Posts
    417
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width