Re: ORACLE 8 ERROR LOGGING: PLEASE HELP ME

From: <mgogala_at_rocketmail.com>
Date: Mon, 11 Jan 1999 14:30:26 GMT
Message-ID: <77d1u2$jtn$1@nnrp1.dejanews.com>

In article <77ce7u$bq1$1_at_nslave1.tin.it>, "Massimiliano" <mazzmax_at_tin.it> wrote:
> Does anybody know if there are some built-in tabels (and witch ones) where
> Oracle stores the errors that occur in the stored-procedures and triggers
> (someone told me that they are stored somewhere...)?
> Thanx.
>
> e-mail me at mazzmax_at_tin.it
>
>

Compilation errors are visible from user_errors view. The best way to see them from sqlplus is to give the following command:

SHOW ERRORS <OBJECT_TYPE> <OBJECT_NAME> For example, for the package body mypack it would read:

SHOW ERRORS PACKAGE BODY MYPACK Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 11 1999 - 08:30:26 CST