Oracle sqlplus executes sql file in windows batch

Question

I have Sqlplus installed and ran a batch file below in cmd.

"D:\setups\instantclient_11_2\sqlplus.exe" username/password@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=111.111.111.11) (PORT=1521)))(CONNECT_DATA=(SID=orcl)))"  @"E:\sql scripts\procedure.sql"

This is what I got. And my procedure means to insert records into a table but that table is still empty.

E:\p01-material big data projects\batch>sql.bat

SQL*Plus: Release 11.2.0.4.0 Production on 星期四 1月 25 11:22:29 2018
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
  6

It stays here forever. And the 6 is here probably because my sql file procedure.sql has 6 lines of statement. How can I make this work?

Thanks

Brackets have meaning in batch. Escape them with the caret ^. — ACatInLove
– ACatInLove, Commented Jan 25, 2018 at 5:50
@ACatInLove, yes and no, not in this case as it is wrapped in double quotes and is seen as the next command after sqlplus — user7818749
– user7818749, Commented Jan 25, 2018 at 7:13

Littlefoot · Accepted Answer · 2018-01-25 06:51:09Z

1

The last line in your PROCEDURE.SQL should be a forward slash, /. It shows SQL*Plus that you've terminated the procedure and will run it.

Or, when you see that "6" (it is the line number; SQL*Plus waits you to enter something), enter / and press "Enter" key on the keyboard.

answered Jan 25, 2018 at 6:51

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Littlefoot Over a year ago

Sure it did! Those are little tricks that people who grew up on SQL*Plus know :)

Collectives™ on Stack Overflow

Oracle sqlplus executes sql file in windows batch

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related