ORA-6510 wrapped PL/SQL no easy access to source

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Tue, 24 Aug 2010 16:10:53 +1000
Message-ID: <AANLkTimp1h-seLxseP1u9VOF5Z43CU4eVgtT+NDmCfuN_at_mail.gmail.com>

 Hi all,

Oracle 11.2

ORA-06510: PL/SQL: unhandled user-defined exception

We are having an issue with a vendor supplied package that is wrapped so I can not look at the source code.
When we call a function from the application the above error shows up in the application log
When we wrap the individual call to the function in a bit of pl/sql and execute it from sql plus it executes just fine and returns the rows as expected.

When we trace the application we can see the statement executed returning no rows and having the "SQL*Net break/reset to client" waits with it. These waits point to an error in the call, but what I really like to see is the actual oracle error generated which is unfortunately hidden by the user defined exception.

How can I find out, without going back to the vendor, what the actual error message is.

I will try "alter system set events '6510 trace name errorstack level 1';", but will it help?

Jack van Zanen

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation


http://www.freelists.org/webpage/oracle-l Received on Tue Aug 24 2010 - 01:10:53 CDT

Original text of this message