SQL & PL/SQL

hi guys,

i have .sql file as below

clear buffer
SET SERVEROUTPUT ON
SET FEED OFF
SET DEFINE OFF
var num_var number

spool /home/test/log_C02
@'/home/test/sqlst.sql'
spool off

spool /home/test/log_C01

@'/home/test/sqlstatements1.sql'

@'/home/test/sqlstatements2.sql_2'

@'/home/test/sqlstatements3.sql_3'

spool off

spool /home/test/log_C03
@'/home/test/sqlsta1.sql'
spool off

quit

in this when "@'/home/test/sqlstatements1.sql'" executes and it fails for some reason , i dont want these two "@'/home/test/sqlstatements2.sql_2'" ,"@'/home/test/sqlstatements3.sql_3'" to execute at all.

How do i prevent this?? ... is there any return code for each statement in Sql*plus?? so that i can check the return code everytime .. or can i pass variables from child sql to parent sql and check the status everytime??... how do i do it?

Edited by: Depakjan on Mar 25, 2011 11:59 AM