execute script from sqlplus command line
Posted on 2007-11-15
I execute sqlplus myuser/mypassword@myhost @c:\temp\batchtest.sql
In the batchtest.sql, I have this :
In the testphm.sql, I have this :
SELECT COUNT(*) INTO tbl_exist FROM user_tables WHERE table_name = 'ADP';
When I execute the prompt is like this :
Oracle9i Release 126.96.36.199.0 - Production
JServer Release 188.8.131.52.0 - Production
It's stop with this "8" which seems the last line number of the script...
Any idea ?