Re: Problem coming out sqlplus from korn shell script

From: Alan Long <tics28_at_>
Date: Thu, 27 Aug 1998 08:21:04 +0100
Message-ID: <tics28-2708980821040001@tics28.sps.mot.com>

In article <35E1ED92.6C620E0A_at_gte.net>, Ramey Muforo <muforo_at_gte.net> wrote:

> When I run an oracle script embeded in korn shell, it executes the
> sqlplus commands, but it finishes, it waits at the sqlplus prompt. What
> do I have to do for it to totally get out of sqplus and return to the
> command line.
>
> Thanks in advance for your help.
> Ramey Muforo
> rmuforo_at_tdcs.tel.gte.com

I had a similar problem. There may be an issue with some of the solutions suggested, in that running the sql script from within sqlplus will also cause the sql script to exit to the shell. Maybe you don't want this.

In my shell script, I use:

exit | sqlplus userid/password @sqlscript parameters

I'm no unix expert but this seems to work for me.

--
Alan Long

email tics28@"spam-off"email.sps.mot.com (remove the "spam-off") Received on Thu Aug 27 1998 - 02:21:04 CDT