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

  • From: Harel Safra <harel.safra@xxxxxxxxx>
  • To: jack@xxxxxxxxxxxx
  • Date: Tue, 24 Aug 2010 09:55:19 +0300

 Take a look here:
http://hz.codecheck.ch/UnwrapIt/Unwrap.jsp

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

Other related posts: