Re: what's more detailed message than SQLERRM

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 02 Dec 2002 23:25:56 +0100
Message-ID: <5dnnuukh44f0fgtc3prst1iaa0144vi4ih@4ax.com>

On Mon, 2 Dec 2002 13:03:35 -0800, "Kenny Yu" <kyu_at_biodiscovery.com> wrote:

>When I run a procedure in sqlplus, I get very detailed error messages,
>including the line numbers where the error originated. I wish to catch such
>errors and log them in a log table. How do I catch the full messages?
>SQLERRM has only one line and has no line numbers.
>
>Kenny
>

use
dbms_utility.format_error_stack in your exception handler

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Dec 02 2002 - 16:25:56 CST