Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Creating trigger
ajaysm85_at_gmail.com wrote:
> 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?
Defiinitely would be better if you could rewrite in PL/SQL
Could you capture the session to a file (redirect STDIO and STDERR to a file when running your batch file), then scan for any failures/errors?
Will depend on if the scripts are disablinhg ECHOing of output.
Cheers Received on Fri Oct 13 2006 - 13:24:46 CDT