Re: Passing an array from a trigger.

From: A. Fox <afox_at_rogers.com>
Date: Sun, 15 Sep 2002 13:19:24 GMT
Message-ID: <wN%g9.34847$561.33074@news02.bloor.is.net.cable.rogers.com>

Another way of doing it without modifying the table (clearing the flag is expensive...) is to create a PL/SQL package with an package array variable (or a memory table). Then, in the "before insert for each row" you can add the record to the array, and in the "after insert" statement-level trigger read the array, call the procedure, and clear the array. Regards.
A. Fox

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:3sm1ou46oi2b3su2gmc1hndntfcq4s5tqu_at_4ax.com...
> On 12 Sep 2002 10:23:57 -0700, vadolt_at_yahoo.com (vdolt) wrote:
>
> >The question, how do I access the whole recordset of records inserted
> >and pass it to procedure?
>
> By flagging them in your table.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Sep 15 2002 - 08:19:24 CDT