Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger: How identify which event fire the trigger.?
You don't receive them in a variable, they are pre-defined (boolean) variables which are available in triggers only.
Hth,
Sybrand Bakker, Senior Oracle DBA
"EMDI" <di.pasquale_at_home.com> wrote in message news:<5Vpb7.12718$DW1.2382397_at_news1.rdc1.mb.home.com>...
> That is exactly what I want. Could you please tell me in wich variable I
> receive "Inserting", "Updating" and "Deleting".
> Thanks
>
> --
>
>
> ------------------------------------
> Make Unlimited phone calls from your PC to ANY phone in the World!
> http://www.eboom.com/free/
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:996898599.23642.0.pluto.d4ee154e_at_news.demon.nl...
> >
> > "EMDI" <di.pasquale_at_home.com> wrote in message
> > news:G4Ga7.8444$DW1.1483534_at_news1.rdc1.mb.home.com...
> > > Hi Guys.
> > > I need to generate a trigger with almost the same logic for Insert,
UPdate
> > > and Delete however I need to know which event fire the trigger in order
to
> > > adjust the code and avoid to create three triggers.
> > >
> > > Thanks
> > > ------------------------------------
> > > Make Unlimited phone calls from your PC to ANY phone in the World!
> > > http://www.eboom.com/free/
> > >
> > >
> >
> > if inserting then
> > else if updating then
> > else
> >
> >
> > etc.
> >
> > Hth,
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> >
> >
Received on Mon Aug 06 2001 - 04:09:41 CDT