SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_FILE.PUT Write Error

473169Nov 30 2005 — edited Dec 1 2005

Hi,

I have a procedure with a FOR cursor IN (SELECT...) loop within which I write the data selected to a file using PUT_LINE. The maximum data written to the file in each loop would be less than 1000 characters. This works fine.

However, when I try using PUT instead of PUT_LINE, it gives a 'write error'. Any idea what could be the problem?

DB version is 9.1.

Thanks in advance,
Vijay.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2005

Added on Nov 30 2005

3 comments

491 views