Re: Forms 4.5; VARCHAR2

In article <35E2D039.B153D99_at_fs-edv.de>, Arnold Schommer <aschommer_at_fs-edv.de> wrote:
> I have a server-side function returning (fragments of)
> sql-scripts. I wanted to store the results in a variable declared as
> VARCHAR2(30000). But if the result exceeds 2000 chars, a exception
> is raised: "ORA–06502 PL/SQL: numeric or value error". The
> problem has to be somewhere between the database and forms: if i use
> substr(*,1,2000) in the function, it works without exception, but
> not, if i use this substr in forms even before the assignment is
> made.
>
> I have two questions:
>
> a) Have i done something wrong or is this a bug (dbms or forms) ?
> b) Can i use other datatypes to avoid this problem (i could use a
> loop to return the values, but since this problem could occur with
> many similair functions, this would cause lots of work) ?

You have hit the 2000-character limit for varchar2 fields. You might try using a LONG datatype.

Steve Cosner Received on Wed Aug 26 1998 - 17:38:33 CEST