Xref: alice comp.databases.oracle.server:28716
Path: alice!news-feed.fnsi.net!news.idt.net!howland.erols.net!sunqbc.risq.qc.ca!news-hub.interserv.net!news.sprynet.com!not-for-mail
From: Sergei Kuchin <skuchin@sprynet.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Problem with utl_file
Date: Wed, 09 Sep 1998 23:49:15 -0500
Organization: Sprynet News Service
Lines: 33
Message-ID: <35F75A4B.F65@sprynet.com>
References: <6t3496$ovt$1@news1.tele.dk> <35F59525.6A772270@cityweb.de>
Reply-To: skuchin@sprynet.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.03Gold (Win95; I)

> 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