Re: is is possible to retrieve a SELECT query's result in a shell script?

Home -> Community -> Usenet -> c.d.o.misc -> Re: is is possible to retrieve a SELECT query's result in a shell script?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 18 May 2002 07:11:05 +0200
Message-ID: <ohobeuo5dk4487lbmr423lr44v6vkghbsm@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 Sat May 18 2002 - 00:11:05 CDT