Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE pkg and client side woes
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 AEGReceived on Thu Oct 23 1997 - 00:00:00 CDT