run sql script from shell script

Question

I have the below shell script that calls an sql script. The problem is it calls the sql script, i enter the username,password ,dbname and after that it creates the table but it doesn't exit from the sql prompt.

test.sh

#!/usr/bin/ksh


sql_test=test.sql

$ORACLE_HOME/bin/sqlplus /nolog @${sql_test}

exit

test.sql

CONNECT &&usr/&&password@&&dbname


CREATE TABLE report1
(
    product_code                       VARCHAR2(30)
  , test_inc                           NUMBER(20,2)

);

Sjuul Janssen · Accepted Answer · 2010-07-19 06:05:30Z

3

Shouldn't you also put an exit statement in test.sql ?

answered Jul 19, 2010 at 6:05

Sjuul Janssen

1,8121 gold badge15 silver badges28 bronze badges

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

1 Comment

Jeffrey Kemp Over a year ago

EXIT is exactly what is needed.

Bob Jarvis - Слава Україні · Accepted Answer · 2010-07-19 11:52:13Z

1

Or you could use a HERE document to eliminate the need to put the exit command into the SQL file:

$ORACLE_HOME/bin/sqlplus /nolog << HERE
@${sql_test};
exit sql.sqlcode
HERE

Share and enjoy.

answered Jul 19, 2010 at 11:52

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

Collectives™ on Stack Overflow

run sql script from shell script

test.sh

test.sql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

test.sh

test.sql

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related