Re: UTL_FILE write to NT Network

From: Erik <erik_at_evd.be>
Date: 8 Nov 2001 22:13:27 -0800
Message-ID: <aeb3790f.0111082213.7f16fc2a_at_posting.google.com>


you need to specify it in your init.ora .... basic oracle !

erik

traceable1_at_hotmail.com (traceable1) wrote in message news:<8551d8c9.0111080630.25a9e09_at_posting.google.com>...
> I am trying to write files to the network using UTL_FILE. I am able
> to run my procedure on my local database and write to my hard drive,
> but when I try to write out to the network drive, it seems to run fine
> (no errors), but it doesn't write anything. I have write rights on
> this drive and can create files there with other apps. (Our Network
> Nazi may have other restrictions I'm unaware of).
> I'm wondering if it's a mapping issue, but if that's the case, this
> won't work well on other people's PCs.
> The UTL_FILE_DIR=*.
>
> DECLARE
> fname varchar2(20) := 'tc3file.txt';
> loc varchar2(10) := 'g:\sql';
> sometext varchar2(20) := 'Some text';
> fhandle utl_file.file_type;
> op varchar2(3) := 'w';
> BEGIN
> fhandle := UTL_FILE.FOPEN(loc,fname,op);
> UTL_FILE.PUT_LINE (fhandle, sometext);
> UTL_FILE.Fclose(fhandle);
> EXCEPTION
> WHEN utl_file.invalid_path then dbms_output.put_line ('Invalid
> Path');
> WHEN utl_file.invalid_mode then dbms_output.put_line ('Invalid
> mode');
> WHEN utl_file.invalid_operation then dbms_output.put_line ('Invalid
> Operation');
> END;
> /
>
> Please advise - any help is very much appreciated!
> Trace
Received on Fri Nov 09 2001 - 07:13:27 CET

Original text of this message