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

From: Harel Safra <>
Date: Tue, 24 Aug 2010 09:55:19 +0300
Message-ID: <>

  Take a look here:

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

Received on Tue Aug 24 2010 - 01:55:19 CDT

Original text of this message