Message-Id: <10618.116916@fatcity.com> From: "Mandar Ghosalkar" Date: Wed, 13 Sep 2000 17:15:59 -0700 Subject: Re: passing variable from sqlplus to korn scripts .. ----- Original Message ----- From: "Thapliyal, Deepak" To: "Multiple recipients of list ORACLE-L" Sent: Wednesday, September 13, 2000 4:01 PM 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@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@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).