UTL_FILE.FOPEN

Hi ,

[Quoted] I am trying to write out a text file from a NT Oracle client onto a Oracle Server machine using the

[Quoted] UTL_FILE.FOPEN utility.

The procedsure I have written is :
[Quoted] procedure open_file (p_ctlDirectory varchar2, p_ctlfilename varchar2) is   begin

     x := UTL_FILE.FOPEN(p_ctlDirectory,p_ctlfilename,'w');   end;

[Quoted] I call this procedure as open_file('c:\share','test.txt')

I get errors like look like this

ORA-06510: PL/SQL:unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 82
ORA-06512: at "SYS.UTL_FILE", at line 120

I would greatly appreciate any help in this regard.

Thanks,
Monty Received on Sun Apr 20 1997 - 00:00:00 CEST