Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with utl_file
> As far as I know you have to configure a special parameter in init.ora
> (UTL_FILE_OUTPUT_DIR or something like that).
"Something like that" is UTL_FILE_DIR
> Marcus Scholten
>
> Ivan Bajon wrote:
>
> > 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 Wed Sep 09 1998 - 23:49:15 CDT