Re: Help Creating trigger

ajaysm85_at_gmail.com wrote:

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

1. Please do not top post. Scroll to the bottom before replying.
2. What you want to do is impossible with one possible exception and that would be the implementation of an AFTER SERVERERROR system event trigger and as they do not trap all errors this is not a guarantee of success.

What you are describing sounds like the implementation of a bad idea. Running a script with 500 SQL statements you can't modify is a recipe for disaster.

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