Re: Help Creating trigger

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 13 Oct 2006 09:55:23 -0700
Message-ID: <1160758519.401853@bubbleator.drizzle.com>

BD wrote:

> ajaysm85_at_gmail.com wrote:

>> I have written a SQL script containing many create/insert statements.i
>> have to write a trigger which will be raised for failure of any
>> statement in that script.can a trigger be written which will be raised
>> for each statement and then the trigger code will check for the
>> status(success or fail) of that statement?or can anybody suggest any
>> proper solution for this?
>>
>> thanks in advance...

>
> You could use a reporting table.

Not without modifying the script ... which the OP claims can not be done.

Though we both know they will be forced to do it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Oct 13 2006 - 11:55:23 CDT