Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating Oracle Trigger

Re: Creating Oracle Trigger

From: Izabella <Izabella.Urbanek_at_afp.gov.au>
Date: Wed, 24 Feb 1999 17:22:46 +1100
Message-ID: <7b0603$mrf$1@platinum.sge.net>


try

sho err trigger upd_sr_equipmnt_status

Michael Pine wrote in message <7avt20$cfg$1_at_otis.netspace.net.au>...
>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 - 00:22:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US