Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Shel Script
On Tue, 15 Jul 1997 22:04:45 -0400, terryg8 <trg_at_ibm.net> wrote:
>RISHI ANAND wrote:
I used Perl to do this, but the principle has to be the same.
You can't just write your sqlplus commands to stdout; Sqlplus won't see them. You have to pipe the commands in. I don't know how to do this sort of redirection in sh. An easy way out is to build a sqlplus command file (you can do this dynamically) and then when it's ready you just
sqlplus name/password @that_file_you_built
The way I did it in perl was to open the sqlplus session
open (SQLPLUS, "| sqlplus name/password");
and then any time I wanted to send a command,
print SQLPLUS "select name, weight, whatever from kitchen_table";
and then you read the results from STDOUT.
Kevin Kelleher Received on Wed Jul 16 1997 - 00:00:00 CDT