Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Trigger
> Andrea 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
You can do:
select * from user_errors;
This show you the code error, message error, and location. Regards.
Juan Buiza Camacho work: jbc_at_guadaltel.pisa.es GuadalTel,s.a. home: jbuiza_at_net.disbumad.es Sevilla (SPAIN)Received on Sun Feb 16 1997 - 00:00:00 CST