passing variable from sqlplus to korn scripts ..

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Wed, 13 Sep 2000 15:01:12 -0700
Message-Id: <10618.116907@fatcity.com>

Hi guys

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

#!/bin/ksh
#
..
.. ksh code
.. ksh code
.. ksh code
..

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

        bdump varchar2(1000);
begin

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

end;
/
exit
__EOF1

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

.. ksh code
.. ksh code
Received on Wed Sep 13 2000 - 17:01:12 CDT