Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 39689
  • Last Modified:

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.
0
s2000_com
Asked:
s2000_com
1 Solution
 
bobbymanochaCommented:
Add a / at the end of the PL/SQL block, like so:

DECLARE
tbl_exist PLS_INTEGER;
BEGIN
SELECT COUNT(*) INTO tbl_exist FROM user_tables WHERE table_name = 'ADP';
END;
/
0
 
s2000_comAuthor Commented:
Thanks a lot !
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now