Can some one help me related to .sql file issue.
I have a .sqlfile and tried to read the file thru unix. In the .sqlfile I have error rows as well and when error comes I dont want to proceed further and need to roll back all the transactions.
sample .sql file below
insert into
test values (9);
update test set id=9 where id=10;
updte test set id=3;
insert into
test values (1);
insert into test values (1);
I tried with "WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK" option also. Can some one help