sql file problem

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

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

please provide the .sql file code