Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger
"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 CST