Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE pkg and client side woes

Re: UTL_FILE pkg and client side woes

From: Andy Hardy <Andy_Hardy_at_camk.demon.co.uk>
Date: 1997/10/23
Message-ID: <ljynXGAu3zT0Mw3o@camk.demon.co.uk>#1/1

In article <344F136F.F6DF45CF_at_ipgrup.com>, Jordi Bellver <jbellver_at_ipgrup.com> writes
> Hi !!
>
>Dan Clamage wrote:
>
>> create a file unique for that user and write it to the server in the
>> specified UTL_FILE_DIR directory. You can use the user name or the
>> unique
>> session id, or both (to distinguish the user logged in twice).
>> > In my utility I need to write stuff out to a file. I want to
>> > use the UTL_FILE package.
>> > Then I try the FOPEN file with a directory on my client box
>
>I saw you are using the UTL_FILE package...
>
> I've some problems specifiying the paths:
>
> I have my UTL_FILE_DIR (in the server) as /tmp (scratch)
>
> When I make a fitxer:=utl_file.fopen('','00_index.txt','w');
>
> ... what must I put in the path ? (first argument)
>
>I tryed '.', './', NULL, etc !!!
>

The first parameter must be one of the paths defined in your UTL_FILE_DIR - in your case:

        fitxer:=utl_file.fopen('/tmp',00_index.txt','w');

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG
Received on Thu Oct 23 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US