Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating Oracle Trigger
try using show errors after running the compile. this will show you the
errors of the currently compiled code.
Michael Pine wrote:
>
> I am getting a trigger compiled with errors message and typing show error
> after the compilation does not report any errors that the compilation was
> talking about.
>
> My trigger is below, i was wondering if anyboyd might have any clues as to
> why my trigger is not working.
>
> regards,
>
> Michael Pine
> mpine_at_pegasussoftware.com.au
>
> create or replace trigger upd_sr_equipmnt_status
> after update of installed ON INSTRMNT
> for each row
> begin
> update setroute.equipmnt SET constat = 6, pri_stat = 'C' WHERE
> setroute.equipmnt.CIN = :new.CIN
> end;
>
> sorry if you need any more information, like ??
Received on Wed Feb 24 1999 - 13:37:33 CST