Re: Trigger

From: Gideon Wheeler <g.wheeler_at_ic.ac.uk>
Date: 1997/02/10
Message-ID: <32FF4E90.1DAB@ic.ac.uk>#1/1

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

try

show errors trigger

by default show errors prints procedure/package errors

OKAY Gids Received on Mon Feb 10 1997 - 00:00:00 CST