RE: passing variable from sqlplus to korn scripts ..

From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
Date: Thu, 14 Sep 2000 11:20:52 +0200
Message-Id: <10619.116953@fatcity.com>

What about in case you have more than one variables returned ?

-----Message d'origine-----
De: Som Priani [mailto:som.priani_at_myprice.com.au] Date: jeudi 14 septembre 2000 04:56
=C0: Multiple recipients of list ORACLE-L Objet: RE: passing variable from sqlplus to korn scripts ..

varx=3D`sqlplus -s / <<EOF
set head off feed off
select value from v\$parameter where name =3D 'background_dump_dest' /
exit
EOF` echo $varx
.............

Use $varx in the shell script
HTH
Som

-----Original Message-----
Sent: Thursday, September 14, 2000 9:02 AM To: Multiple recipients of list ORACLE-L

Hi guys=20

goin thru a brain freeze here .. ur help appreciated in advance=20 here is the deal ...

#!/bin/ksh
#
..
.. ksh code=20
.. ksh code=20
.. ksh code=20
..

$ORACLE_HOME/bin/sqlplus -s / <<__EOF1
declare

bdump varchar2(1000);
begin

	select value
		into bdump
		from v$parameter
		where name =3D'background_dump_dest';

end;
/
exit=20
__EOF1

how to accesss bdump variable value from sql*plas here in shell = script ??**************

.. ksh code=20
.. ksh code=20
..

Thx
deepAk
--=20
Author: Thapliyal, Deepak
INET: DThapliyal_at_ea.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=20
Author: Som Priani
INET: som.priani_at_myprice.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------