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

Home -> Community -> Usenet -> c.d.o.tools -> Re: My Trigger Question

Re: My Trigger Question

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 25 Sep 2000 09:57:31 +0200
Message-ID: <8qn0i7$2hg$1@s1.read.news.oleane.net>

I'm afraid that using :new for each field is the only way.

--
Have a nice day
Michel


ozi <spuzic_at_camtech.net.au> a écrit dans le message : Z%mz5.5135$O7.82104_at_ozemail.com.au...

> Hi Everyone,
>
> I have set up a trigger on a table which fires whenever a row is inserted.
> What I need to know is how do I obtain the new row which has been inserted
> as a WHOLE instead of just the individual attribute values (like you would
> get if you used :new and :old). I've looked everywhere but can't find the
> answer. There has got to be an easy solution. I'm loosing faith in ORACLE
> ingenuity rather quickly.
>
> I'll be very thankful if anyone can help
> Regards,
> Ozi
>
>
Received on Mon Sep 25 2000 - 02:57:31 CDT

Original text of this message

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