Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_File coud not write on samba mount point

user10911131Mar 17 2011 — edited Mar 21 2011
Hello,

I have the follow problem with this code:
DECLARE
fHandle UTL_FILE.FILE_TYPE;
BEGIN
fHandle := UTL_FILE.FOPEN('NAS_VR_DIR', 'myoutput', 'W');
UTL_FILE.PUTF(fHandle, ' --- Heading 1 ---\n');
UTL_FILE.PUTF(fHandle, ' --- Heading 2 ---\n');
UTL_FILE.PUTF(fHandle, ' --- Heading 3 ---\n');
UTL_FILE.FCLOSE(fHandle);
EXCEPTION
WHEN utl_file.invalid_path THEN
raise_application_error(-20000, 'ERROR: Invalid path for file.');
END;
/

If I started it in sql*plus on the database server, it works.
If I started it on the sql*plus on the local pc, it doesn't work:
FEHLER in Zeile 1:
ORA-29283: Ung³ltiger Dateivorgang
ORA-06512: in "SYS.UTL_FILE", Zeile 536
ORA-29283: Ung³ltiger Dateivorgang
ORA-06512: in Zeile 5

Can anybody help me?

Thanks Tom
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2011
Added on Mar 17 2011
6 comments
588 views