Hi all,
I have recently come across a script which has not been tested properly and it was having an error which sqlplus did not detect.
Here the example:
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 12 11:50:18 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> update emp
2 set comm=1
3 where empno=7369
4
SQL> commit;
Commit complete.
SQL>
As you can see the update statement missed the semicolon at the end or the slash on the next line and the update statement has not been executed.
Is there any way to avoid this problem (apart writing correctly and testing properly the script)?
Regards.
Alberto