Re: Help Creating trigger

From: EdStevens <quetico_man_at_yahoo.com>
Date: 12 Oct 2006 05:24:55 -0700
Message-ID: <1160655895.604283.171040@e3g2000cwe.googlegroups.com>

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...

Forget the trigger. Write your SQL script in PL/SQL and use the error handling features available there. Received on Thu Oct 12 2006 - 07:24:55 CDT