Problem Generate:-
abc.txt
update table xxx set sal=sal+100 where empid=1;
update table xxx set sal=sal+100 where empid=2;
update table xxx set sal=sal+100 where empid=3;
commit;
update table xxx set sal=sal+100 where empid=4;
update table xxx set sal=sal+100 where empid=5;
update table xxx set sal=sal+100 where empid=6;
commit
update table xxx set sal=sal+100 where empid=7;
update table xxx set sal=sal+100 where empid=8;
commit;
spool '/u01/log.log'
@ abc.txt
spool off
check log.log file & see the error
1 row updated
update table xxx set sal=sal+100 where empid=7;
*
ERROR at line 2:
ORA-02185: a token other than WORK follows COMMIT
Solution:-
check your code and see if you add (:) colon instead of ( ; ) semicolon after the COMMIT in your code.
abc.txt
update table xxx set sal=sal+100 where empid=1;
update table xxx set sal=sal+100 where empid=2;
update table xxx set sal=sal+100 where empid=3;
commit;
update table xxx set sal=sal+100 where empid=4;
update table xxx set sal=sal+100 where empid=5;
update table xxx set sal=sal+100 where empid=6;
commit
update table xxx set sal=sal+100 where empid=7;
update table xxx set sal=sal+100 where empid=8;
commit;
spool '/u01/log.log'
@ abc.txt
spool off
check log.log file & see the error
1 row updated
update table xxx set sal=sal+100 where empid=7;
*
ERROR at line 2:
ORA-02185: a token other than WORK follows COMMIT
Solution:-
check your code and see if you add (:) colon instead of ( ; ) semicolon after the COMMIT in your code.
2 comments:
Thanks Mate.....
Oh thanks, that is what happened to me in Orace 11g with SqlDeveloper.
Post a Comment