Re: OT Unix shell variable question

Scott - I have used it w/out problems, sample below:

<snip ksh script>

PFILE=$ORACLE_HOME/dbs/initorsp.ora

svrmgrl <<EOF
connect internal
startup nomount pfile=$PFILE
EOF </snip ksh script>

PS. You have noticed your env. variables are different, right?

>>> Scott.Shafer_at_dcpds.cpms.osd.mil 05/29/01 03:41PM >>>
I am trying to pass a shell variable into a "here document" in a unix shell script, i.e.,

export PASSWORD=the_pass

svrmgrl << EOF
connect user/$PASS
do_stuff_here;
commit;
exit
EOF I have tried: "$PASS" , \$PASS , and just plain $PASS - no dice. Anyone know how to do this? I spent too many hours in the sun this past weekend and am drawing a blank...

Thanks,

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grāce via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue." --Jay Trigg

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author:
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil 

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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