Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: is is possible to retrieve a SELECT query's result in a shell script?
Thank you I will consider this option
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:ohobeuo5dk4487lbmr423lr44v6vkghbsm_at_4ax.com...
> On Thu, 16 May 2002 18:32:02 +0200, "Grégory Luguet"
> <gregory.luguet_at_evidian.com> wrote:
>
> >I am answering myself : I use the SPOOL directive to write the result in
a
> >file that I later parse
> >
> >> Hello all,
> >>
> >> I have to subordinate a procedure to the content of a field in a table.
> >> I can launch sql procedures in .sql files from my script, but now I
need
> >to
> >> retrieve a result : is it possible? and if so, how?
> >> I use Oracle 8i (8.1.6 & 8.1.7) DB and my script runs on Unix (AIX or
> >SunOS)
> >>
> >> thanks in advance
> >>
> >>
> >
>
> No need to spool. Piping the output definitely will work provided you
> use sqlplus -s and set feedback off inside your script.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed May 22 2002 - 03:54:05 CDT