sql file problem

[susarlasireesha]

I have a .sql file it contains creation scripts,procedures,packages
when ever an error occur in creation scripts /procdures/packages
i must show error message and come out of the execution of .sql file.how
it is possible

[krishnaindia2007]

Why are you querying the database in this fashion with scripts that have not been tested ?

[phanikanthmn]

please provide the .sql file code