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
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: 17410

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 agree. Here's the link:
subject: sqlplus in shell script
It's not a secret anymore!