s2000_com
asked on
execute script from sqlplus command line
Hi,
I execute sqlplus myuser/mypassword@myhost @c:\temp\batchtest.sql
In the batchtest.sql, I have this :
spool C:\Temp\test1.txt
@C:\Temp\testphm.sql
spool off
exit
In the testphm.sql, I have this :
DECLARE
tbl_exist PLS_INTEGER;
BEGIN
SELECT COUNT(*) INTO tbl_exist FROM user_tables WHERE table_name = 'ADP';
END;
When I execute the prompt is like this :
Connected to:
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production
8
It's stop with this "8" which seems the last line number of the script...
Any idea ?
TIA.
I execute sqlplus myuser/mypassword@myhost @c:\temp\batchtest.sql
In the batchtest.sql, I have this :
spool C:\Temp\test1.txt
@C:\Temp\testphm.sql
spool off
exit
In the testphm.sql, I have this :
DECLARE
tbl_exist PLS_INTEGER;
BEGIN
SELECT COUNT(*) INTO tbl_exist FROM user_tables WHERE table_name = 'ADP';
END;
When I execute the prompt is like this :
Connected to:
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production
8
It's stop with this "8" which seems the last line number of the script...
Any idea ?
TIA.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER