Re: How to read over 2000 characters in a data file?

From: Patrick Flahan <flahan_at_southeast.net>
Date: 1997/10/28
Message-ID: <635upn$7am@news.southeast.net>#1/1

Jimmiy,
The maximum size of a varchar2 in pl/sql is about 32,000 characters, so this should give you plenty of room to play with. The 2000 size limit is actually for a column of the varchar2 type in a table.

Hope this helps,
Patrick Flahan

Jimmy wrote in article <34557DB9.12D3_at_comp.polyu.edu.hk>...

>I want to use text_io packages to read data file content in Form 4.5. I
>declare a variable to hold each line input as varchar2(2000). (since the
>max. characters hold in varchar2 is 2000)
>If a row in the data file is over 2000 characters, how can I read such
>line with text_io package in Form 4.5?
>
>Thanks,
>Jimmy
Received on Tue Oct 28 1997 - 00:00:00 CST