Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem with utl_file
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