Re: Problem coming out sqlplus from korn shell script

From: Mungo Henning <mungoh_at_itacs.strath.ac.uk>
Date: Fri, 28 Aug 1998 16:21:51 +0100
Message-ID: <35E6CB0F.93C093EC@itacs.strath.ac.uk>

Alan Long wrote:

> In my shell script, I use:
>
> exit | sqlplus userid/password @sqlscript parameters
>
> I'm no unix expert but this seems to work for me.

With good humour, I'd conclude with the first four words of that last sentence! :-)

Did you mean to run:

echo "exit" | sqlplus ...

Without the "echo" bit you are piping the output of the shell exit to sqlplus - don't think that this is wise. (I tried a simple incantation and here's the output:

exit | echo hi
hi
[2] 1724
%: Reset tty pgrp from 1724 to 1275

Okay, so now I've left myself open to be corrected by the Unix experts... you feedback/education welcomed.

Regards

Mungo Henning Received on Fri Aug 28 1998 - 10:21:51 CDT