UTL_FILE_DIR - Can I use environment var ?

[KC]

Hi,

Question: We are using Oracle 7.3.4 and I am using the UTL_FILE to
output data to a file

In Oracle INIT.ORA, I added this sentence

UTL_FILE_DIR = $LOG_PATH/log

where I added a line in .cshrc file for Unix userid = oracle, this sentence

setenv $LOG_PATH = /users/dev

I executed the stored procedure that calls UTL_FILE.FOPEN but I got a
INVALID_OPERATION exception.

It seems it doesn't recognise Environment variable $LOG_PATH. Anyone knows
how do I make it work ?

Thanks & Rgds
Kevin Chong

Thanks!
Dawn

[jmveg...@my-deja.com]

In article <7pdk8b$asl$1...@nobel2.pacific.net.sg>,

Hi Kevin,

The UTL_FILE package not recognise Environments variables.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

[Kirpichev Alexander]

In relcom.comp.dbms.oracle KC <clob...@yahoo.com> wrote:
K> Hi,

K> Question: We are using Oracle 7.3.4 and I am using the UTL_FILE to
K> output data to a file

K> In Oracle INIT.ORA, I added this sentence

K> UTL_FILE_DIR = $LOG_PATH/log
UTL_FILE_DIR = $LOG_PATH/log/
^just add trailing slash here
and here: v
UTL_FILE.FOPEN('...log/'

K> where I added a line in .cshrc file for Unix userid = oracle, this sentence

K> setenv $LOG_PATH = /users/dev

K> I executed the stored procedure that calls UTL_FILE.FOPEN but I got a
K> INVALID_OPERATION exception.

K> It seems it doesn't recognise Environment variable $LOG_PATH. Anyone knows
K> how do I make it work ?

K> Thanks & Rgds
K> Kevin Chong

K> Thanks!
K> Dawn