How to validate SQL scripts

[parthi1705]

Hi,
How to Validate SQL scripts?
I am having set of sql files i wish to run one by one if there is any error at one file i need to notify to the user.I have created Bat file in-order to execute in a sequence.how to validate in bat file
say

01.sql ---Sucess
02.sql --- Fail -- intimate and not to execute rest of sql files
03.sql
04.sql

Thanks!

[Endoro]

this will only work, if your SQL program sets an exit code OR creates new tables, reports etc. in case of success.

[parthi1705]

That is what i am asking how to do so if there was an errror. Validation on the script.

[foxidrive]

Are you using SQLPlus?

[parthi1705]

The files are oracle file. I have saved in .SQL format.

[foxidrive]

How are you executing the queries?

Above you were told by Endoro that the method you use had to return an errorlevel, or test by existence of the files, and that sounds reasonable to me.

We aren't mind readers - you have to provide details for people to give advice on.