Exiting out of Shell script

dennis_allan · #1 (**permalink**) 04-19-04, 16:02

Hello,
I have a Bourne Shell script that first calls sqlldr then logs into SQL Plus to run a PL/SQL script. However, when I run this script, I need to type in 'exit' or <ctrl-d> to get back to the prompt. I would like to be able to run the script and have the cursor return automatically. Here is my script:
#!/bin/sh
sqlldr <usrname>/<pw> control = control.ctl
sqlplus -s <username>/<pw> @script3.txt
exit
EOF

Any help is appreciated. Thanks.

Dennis

aigles · #2 (**permalink**) 04-20-04, 01:50

First solution, use HERE document :

Code:

#!/bin/sh
sqlldr <usrname>/<pw> control = control.ctl
sqlplus -s <username>/<pw> @script3.txt <<EOD
exit
EOF

Second solution (the best one), redirect stdin to /dev/null :

Code:

#!/bin/sh
sqlldr <usrname>/<pw> control = control.ctl
sqlplus -s <username>/<pw> @script3.txt </dev/null

shivnarayan · #3 (**permalink**) 05-01-04, 10:40

Thanx for this post. This has solved my problem also.

Regards,
Shiv

Internet Services

Web Development

Digital Marketing

Consumer Tech