RE: passing variable from sqlplus to korn scripts ..

From: Som Priani <som.priani_at_myprice.com.au>
Date: Thu, 14 Sep 2000 12:50:04 +1000
Message-Id: <10618.116925@fatcity.com>

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

Use $varx in the shell script
HTH
Som

-----Original Message-----
From: Thapliyal, Deepak [mailto:DThapliyal_at_ea.com] Sent: Thursday, September 14, 2000 9:02 AM To: Multiple recipients of list ORACLE-L Subject: passing variable from sqlplus to korn scripts ..

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
..

Thx
deepAk

-- 
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).

Received on Wed Sep 13 2000 - 21:50:04 CDT