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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to use a statement level trigger?

Re: How to use a statement level trigger?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 27 Apr 2005 07:30:55 -0700
Message-ID: <1114612255.807748.262920@z14g2000cwz.googlegroups.com>


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

Original text of this message

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