UTL_FILE.FOPEN

From: monty <monty_at_enteract.com>
Date: 1997/04/20
Message-ID: <5je040$8dd@eve.enteract.com>#1/1

Hi ,

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

UTL_FILE.FOPEN utility.

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

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

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 CDT