Re: Exception Description?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 16 Aug 2001 01:44:10 -0700
Message-ID: <a20d28ee.0108160044.16ea5046@posting.google.com>

e9926043_at_student.tuwien.ac.at (Sebastian Scholz) wrote in message news:<3b7ae7d1.18954425_at_news.tuwien.ac.at>...
> Hello,
>
> Is there a way to get a meaningful description of an Exception if one
> was raised? - I'm using in the Exception Handler "WHEN OTHERS" and
> would like to know the exact Error Code and Description.
>
> Sebastian

Check the sqlerrm function in your pl/sql documentation or the dbms_utility.format_error_stack function in the Oracle supplied packages manual.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 16 2001 - 03:44:10 CDT