Run sql script from bat file (oracle, batch)

Question

I have bat script:

@echo off
cls
:start
sqlplus user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=X.Y.Z.F)(Port=1521))
                               (CONNECT_DATA=(SID=some_sid))) @test.sql
goto end

:end
pause 0

and my test.sql

DECLARE
test varchar2(32000);
BEGIN
  test:='value';
  DBMS_OUTPUT.PUT_LINE('string test');
  DBMS_OUTPUT.PUT_LINE(test||' test');
END;

When I run it I got this:

What it means?

Unless it's executed automatically by your setup, you'll also need to do a SET SERVEROUTPUT ON before your DECLARE statement in order to show the output from DBMS_OUTPUT. — cdub
– cdub, Commented Jun 14, 2019 at 22:06

cdub · Accepted Answer · 2019-06-14 22:02:49Z

5

You need to enter a forward slash (/) to flush the buffer.

DECLARE
test varchar2(32000);
BEGIN
  test:='value';
  DBMS_OUTPUT.PUT_LINE('string test');
  DBMS_OUTPUT.PUT_LINE(test||' test');
END;
/   <<<<<<<<<<<<<----- forward slash

answered Jun 14, 2019 at 22:02

cdub

2,3179 silver badges14 bronze badges

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

2 Comments

cdub Over a year ago

You bet! Note that I added a comment to the original post as well.

alexherm Over a year ago

Yeap. / is all you need.

Collectives™ on Stack Overflow

Run sql script from bat file (oracle, batch)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related