File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Linux / UNIX and the fly likes sqlplus in shell script Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Engineering » Linux / UNIX
Bookmark "sqlplus in shell script" Watch "sqlplus in shell script" New topic

sqlplus in shell script

ajse ruku
Ranch Hand

Joined: May 06, 2005
Posts: 196
I am using sqlplus in my shell script in the following way

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

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

Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16897

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;
[ February 01, 2008: Message edited by: Tim Holloway ]

Customer surveys are for companies who didn't pay proper attention to begin with.
I agree. Here's the link:
subject: sqlplus in shell script
jQuery in Action, 3rd edition