Re: Read over 2000 characters in Forms 4.5?
From: Joe Strano <jstrano_at_dulcian.com>
Date: 1998/01/13
Message-ID: <69hba7$9cm_at_bgtnsc01.worldnet.att.net>#1/1
Date: 1998/01/13
Message-ID: <69hba7$9cm_at_bgtnsc01.worldnet.att.net>#1/1
In a quick test, I was able to place 58,571 characters into a TEXT ITEM in Forms 4.5. I have also heard that a VARCHAR2 variable in PL/SQL can be up to 32,767 characters. A varchar2 column in the database is the only one limited to 2,000 characters.
-- Joe Strano Dulcian, Inc. -------------------------- Jimmy wrote:Received on Tue Jan 13 1998 - 00:00:00 CET
>
> Hello all,
>
> How can I read a line from a text file with a line over 2000 characters long? (in Forms
> 4.5) Since the max. characters of varchar2 in Forms is 2000, when I use text_io.get_line
> function, the Forms raises the VALUE_ERROR exception when the line is over 2000 characters. Is it
> possible to read over 2000 characters in Forms PL/SQL?
>
> Thanks,
> Jimmy