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!

Reading single-line unlimited length text file

225648Jan 13 2003 — edited Jan 21 2003

Hi all.

I'm writing a program to read a single-line unlimited length string from a text file.

I tried to use PL/SQL Packages' UTL_FILE.FOPEN to open it but the size is limited to 32767...
(UTL_FILE.FOPEN(in_filepath, in_filename, 'r',32767);)

Is there any other function I can use?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 18 2003

Added on Jan 13 2003

12 comments

1,540 views