jQuery in Action, 3rd edition
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
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: 17038

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 ]

An IDE is no substitute for an Intelligent Developer.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: sqlplus in shell script
It's not a secret anymore!