Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to use a statement level trigger?
Ford, If Oracle has enabled this somehow over the last couple of
releases I missed seeing any mention of it. It would be nice if you
could reference the entire insert array from a single statement level
trigger and then perform just one bulk insert to the audit/history
table but I do not believe it is possible. If you need to capture
changes on the row level then I think you are stuck using a row level
trigger to capture the row level information that basically converts
the bulk insert into a single row insert. Though use of bulk insert
could still save a few round trips to the DB from the application.
HTH -- Mark D Powell -- Received on Wed Apr 27 2005 - 09:30:55 CDT
![]() |
![]() |