thanks for reply..
i will explain in brief what i am trying to implement.pls suggest can
it be done?
I am having many SQL scripts each containing atleast 500 SQL statements
and i am not allowed to modify that.Now what i wanted to do is create a
DOS batch file and execute all the SQL scripts at a time.In this i have
to maintain a log for the statements that will fail.i will make use of
the UTL_FILE package for this.so i thought trigger would be a better
idea.i found schema level triggers are not yet supported so i wanted to
know is there any better way to do this without modifying the scripts?
EdStevens 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...
>
> Forget the trigger. Write your SQL script in PL/SQL and use the error
> handling features available there.
Received on Fri Oct 13 2006 - 00:46:32 CDT
