I have multiple batch processes that run in parallel and enter new
records into the table. In the insert trigger on that table I pass
each record to procedure. SO, when I am entering 10000 records I call
procedure 10000 times.
To make it more efficient I wanted to change trigger to fire once
after the whole insert statement, but I guess the problem is that :new
and :old are only available "FOR EACH ROW" type of triggers.
The question, how do I access the whole recordset of records inserted
and pass it to procedure?
Reminder: I can't just select them from the table by primary key,
because there are could be many processes inserting records into the
table at the same time.
Thank you.
Received on Thu Sep 12 2002 - 12:23:57 CDT
