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: Eric Givler <egivler_at_flash.net>
Date: Mon, 25 Sep 2000 21:26:38 GMT
Message-ID: <iqPz5.8132$864.503864@news.flash.net>

goto www.revealnet.com/plsql-pipeline.
Steve Feuerenstein created a wrapper that will put the new and old values into record structures for triggers. I haven't looked at it yet, but it sounded like a good idea.

ozi <spuzic_at_camtech.net.au> wrote in message news: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 - 16:26:38 CDT

Original text of this message

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