Forums Register Login

sqlplus in shell script

+Pie Number of slices to send: Send
Hi,
I am using sqlplus in my shell script in the following way

sqlplus <username>/<password> <<ENDOFSQL >
select * from dual;
exit
ENDOFSQL

But the problem is that sqlplus is not exiting after completion.Its remaining as abandoned process.
Pleas suggest something to solve this problem.

regards,
Ajse
+Pie Number of slices to send: Send
I hope your "here script" got garbled by our UBB formatter or it shouldn't have even done that much.

The proper syntax would be:

sqlplus / <<ENDOFSQL
select * from dual;
exit
ENDOFSQL
[ February 01, 2008: Message edited by: Tim Holloway ]
Your mother is a hamster and your father smells of tiny ads!
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 8415 times.
Similar Threads
stored procedure
problem running sqlplus using Runtime.exec()
Executing shell script from java
sqlplus and shell script
create store procedure using shell script.
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 03:05:58.