From: "Huy Vu" <huyv@usa.net>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
Subject: How to define Unix environment variables in the sql files
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Organization: AEI Internet Inc <http: //www.aei.ca/>
Message-ID: <983658011.241951@news.aei.ca>
Cache-Post-Path: news.aei.ca!unknown@hv-hs-39-172.aei.ca
X-Cache: nntpcache 2.4.0b3 (see http://www.nntpcache.org/)
Date: Sat, 03 Mar 2001 22:20:11 GMT
NNTP-Posting-Host: 206.123.6.7
NNTP-Posting-Date: Sat, 03 Mar 2001 15:20:11 MDT


Hi all,

I tried to define an Unix environment variable in an sql file but not
successful.

I can put '?' to replace $ORACLE_HOME variable but not others.

Does someone know how to define an Unix environment in the sql files.

Thanks in advance for any help.

DH.