Re: UTL_FILE paths
From: cpbbb <cpbrady_at_frontiernet.net>
Date: 1998/03/07
Message-ID: <6ds1qm$fi2$1_at_node17.frontiernet.net>#1/1
TL wrote in message <01bd46b8$93b9dc40$2e4e3dd1_at_l58cb9>...
>I am having a similar problem on NT. I am trying to use the
>UTL_FILE.FOPEN, and I get the invalid path error,
>even though the D:\ORANT\BWVAUDIT directory is in the Oracle ini file,
>which is called "initorcl.ora" on our db.
>Code follows...Any ideas? I tried it with and without the last "\".
>Michael R. Shoop <mshoop_at_zeltech.com> wrote in article
><34F6CC06.3FC0D754_at_zeltech.com>...
>> In my init.ora file I have --
>>
>> utl_file_dir = /usr/tmp
>>
>> which is suppose to define the path into which a file can be opened when
>> using the utl_file package. However, in my pl/sql code, when I make a
>> call such as
>>
>> declare
>> file_id utl_file.file_type;
>> begin
>> file_id := utl_file.fopen('/usr/tmp/','test.lis','W');
>> ....
>> ....
>> ...
>> the invalid path exception is raised. Any ideas on why this would be?
>> The permissions are open on /usr/tmp. When I change the utl_file_dir
>> parameter to be
>>
>> utl_file_dir = *
>>
>> the fopen command works fine. Again, anyone have a clue why the code is
>> not working properly?
>>
>> Thanks in advance,
>>
>> Mike Shoop
>>
Received on Sat Mar 07 1998 - 00:00:00 CET
Date: 1998/03/07
Message-ID: <6ds1qm$fi2$1_at_node17.frontiernet.net>#1/1
On Oracle 7.2.3, I have seen the UTL_FILE package go 'invalid' for no seemingly good reason. Try re-running the Oracle supplied catalog script which sets up the UTL_FILE capability. We've tried this option and it seems to work.
Craig Brady
cpbrady_at_frontiernet.net
TL wrote in message <01bd46b8$93b9dc40$2e4e3dd1_at_l58cb9>...
>I am having a similar problem on NT. I am trying to use the
>UTL_FILE.FOPEN, and I get the invalid path error,
>even though the D:\ORANT\BWVAUDIT directory is in the Oracle ini file,
>which is called "initorcl.ora" on our db.
>Code follows...Any ideas? I tried it with and without the last "\".
>Michael R. Shoop <mshoop_at_zeltech.com> wrote in article
><34F6CC06.3FC0D754_at_zeltech.com>...
>> In my init.ora file I have --
>>
>> utl_file_dir = /usr/tmp
>>
>> which is suppose to define the path into which a file can be opened when
>> using the utl_file package. However, in my pl/sql code, when I make a
>> call such as
>>
>> declare
>> file_id utl_file.file_type;
>> begin
>> file_id := utl_file.fopen('/usr/tmp/','test.lis','W');
>> ....
>> ....
>> ...
>> the invalid path exception is raised. Any ideas on why this would be?
>> The permissions are open on /usr/tmp. When I change the utl_file_dir
>> parameter to be
>>
>> utl_file_dir = *
>>
>> the fopen command works fine. Again, anyone have a clue why the code is
>> not working properly?
>>
>> Thanks in advance,
>>
>> Mike Shoop
>>
Received on Sat Mar 07 1998 - 00:00:00 CET