RE: Problems with UTL_FILE

It looks like you're blowing the 1023 line limit.

I'd also suggest you build up the string with concatenation and do 1 'put' per line.

George.

> -----Original Message-----
> From: "Barlow, Steve" <barlows_at_bsci.com> [mailto:barlows_at_bsci.com]
> Sent: Tuesday, May 23, 2000 10:11 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: Problems with UTL_FILE
>
>
> > Hi,
> >
> > I'm having some difficulty using UTL_FILE to write some
> records out to a
> > pipe delimited flat file. The file is opened correctly and
> the first row
> > is written to the file. The loop continues and after the
> second fetch the
> > script bombs with a UTL_FILE.WRITE_ERROR. I have tested the
> cursor SQL and
> > it is extracting many rows (248) to be exact. The init.ora
> has the correct
> > entry and the database has been bounced and, since the file is being
> > written to at least once I'm assuming the UTL_FILE
> requirements are being
> > met. Any ideas?
> >
> > <<postings.sql>>
> >
> > Thanks you,
> >
> > Steve Barlow
Received on Wed May 24 2000 - 05:20:06 CDT