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

It'll unwrap the code and you can debug further.

Harel Safra

On 24/08/2010 09:10, Jack van Zanen wrote:
> Hi all,
> Environment:
> Oracle 11.2
> Error:
> 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