Re: Trigger
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/02/03
Message-ID: <5d4lvc$d9q$1_at_newton.pacific.net.sg>#1/1
Date: 1997/02/03
Message-ID: <5d4lvc$d9q$1_at_newton.pacific.net.sg>#1/1
"Andrea" <A.Savino_at_agora.stm.it> wrote:
>Hi and sorry for my english,
>I have a question. Usually I work with Oracle 7.2 Now I'm testing my
>database on Oracle 7.3 and creating a trigger I got this message:
>
>Trigger created with compilation errors
>
>Now, on Oracle 7.3 the triggers are compilated (on 7.2 no).
>
>How I can show errors, if I try with 'show error' Oracle return 'No error'
>
>Thanks
>Andrea Savino
>A.Savino_at_agora.stm.it
Hi there,
You can query against DBA_ERRORS / User_errors / ALL_ERRORS data dictionary against the object name
Regards
N.Prabhakar Received on Mon Feb 03 1997 - 00:00:00 CET