UTL_FILE Write Error

From: <Dawn.Hoffmann_at_reedtech.com>
Date: Fri, 13 Aug 1999 19:20:43 GMT
Message-ID: <7p1r60$bl4$1@nnrp1.deja.com>

Hi,

Question: We are using Oracle 7.3.4 and I am using the UTL_FILE to output data to a file. I know there is a limitation of 1023 bytes when writing out a record. Does this limitation apply to the PUT and PUT_LINE commands even if the PUT is used in a loop (where a chunk of data smaller than 1023 bytes) and then a NEW_LINE is used? It happens to bomb (with a write error) on a record that has a length greater than 1023 when the NEW_LINE is used. The write error occurs when the file is closed. No record is written.

Thanks!
Dawn

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 13 1999 - 14:20:43 CDT