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). 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 Tue Sep 08 1998 - 00:00:00 CDT