Re: Problem with fetching large amount of text into form item
From: Maoz Mussel <mmussel_at_iil.intel.com>
Date: Fri, 24 Jul 1998 00:53:57 +0200
Message-ID: <35B7BF05.63D0_at_iil.intel.com>
Date: Fri, 24 Jul 1998 00:53:57 +0200
Message-ID: <35B7BF05.63D0_at_iil.intel.com>
Thanks, but this shouldn't be the problem: the long_text field in the database is also defined as varchar2(2000). I defined the ITEM as long, expecting it will act as long (i.e. no size limitation), but it's appear it doesn't. Also, the VALUE_ERROR exception is raised when trying to insert large text into the item, and not when fetching the record into line_val variable.
Thanks again, and let me know if you have further ideas.
Maoz
roli wrote:
>
> maybe you´ve got a datatype error?
> line_val is Varchar2(2000) and long_text is long
>
> if long_text is longer than (2000) trouble will appear! So line_val should
> also be long.
>
> roland
Received on Fri Jul 24 1998 - 00:53:57 CEST