Re: Problem coming out sqlplus from korn shell script

From: <prochak_at_my-dejanews.com>
Date: Wed, 26 Aug 1998 17:45:32 GMT
Message-ID: <6s1hjr$n9k$1@nnrp1.dejanews.com>

Ramey,

In what way was it "unsuccessful"? Post a sample of your scripts that demonstrates the problem. Then we can be more specific in helping you.

You can use:

EXIT SUCCESS for example in your SQL/PLUS script (say it is filename test.sql). then execute it as:

sqlplus user/password <test.sql
echo $? is the exit status

in just about any UNIX shell.

Let us know.

In article <6rue8n$rb2$2_at_news.gte.com>, remigius.muforo_at_telops.gte.com (Ramey Muforo) wrote:
> I have already tried that line but it was unsuccessful.
>
> In article <35E22906.BAB6CE4E_at_deere.com>, jh33378_at_deere.com says...
> >
> >Insert one more line: EXIT
> >
> >Ramey Muforo 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
> >
> >
> >
>
>

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 12:45:32 CDT