utl_file Package

From: Bill Buchan <bbuchan_at_ossian.net>
Date: Mon, 10 Aug 1998 17:53:01 +0100
Message-ID: <6qn8dm$oqv$1@phys-ma.sol.co.uk>

I'd very much appreciate any help in getting the following code running using the utl_file package:

DECLARE

     file_aaa  utl_file.file_type;
     file_text  varchar2(80);

BEGIN
 file_aaa := utl_file.fopen('C:\Temp','ORACLE_testfile','w');  file_text := 'Gibberish';
 utl_file.put_line(file_aaa,file_text);  utl_file.fclose(file_aaa);
END;
/

I have set the parameter

utl_file_dir = C:\Temp

in my init_.ora file and have bounced the database. I am running the code on the server-side but it merely returns exceptions - I am using Oracle8 on WinNT4.

Any help would be much appreciated,

Thanks,

• Bill.

Received on Mon Aug 10 1998 - 11:53:01 CDT