Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with utl_file

Problem with utl_file

From: Ivan Bajon <ib_at_ed.dk>
Date: Tue, 8 Sep 1998 13:30:45 +0200
Message-ID: <6t3496$ovt$1@news1.tele.dk>


I'm experimenting with file I/O from within PL/SQL. I try to run this in SQL*Plus

declare

   type file_type is record (id binary_integer);    myfile file_type;
begin

   myfile := utl_file.fopen('C:\temp\','out.txt', 'w');    utl_file.put_line(myfile, 'aaaa');
   utl_file.fclose(myfile);
end;
/

but I get the line

myfile := utl_file.fopen('C:\temp\','out.txt', 'w');

and a ORA-06550 followed by PLS-00382 (invalid type) along with some additional errors. According to the documentation, I'm doing things right. Can anyone tell me what I do wrong? Oh, I better say that I am, of course, trying this on an Oracle7.3.

Thanks in advance
- Ivan Bajon Received on Tue Sep 08 1998 - 06:30:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US