Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problems with UTL_FILE

RE: Problems with UTL_FILE

From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Thu, 25 May 2000 00:29:35 -0400 (EDT)
Message-Id: <10507.106615@fatcity.com>


Hey,
Do you FFLUSH the buffer after you do your PUT or PUTF or PUTLINE? Your buffer might be getting over 1022 bytes.

HTH
Lyall Barbour

------Original Message------
From: "Barlow, Steve" <barlows_at_bsci.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 23, 2000 9:11:26 PM GMT
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
>
>



FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup Received on Wed May 24 2000 - 23:29:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US