Forms 4.5; VARCHAR2
From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Tue, 25 Aug 1998 16:54:49 +0200
Message-ID: <35E2D039.B153D99_at_fs-edv.de>
[Quoted] 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.
Date: Tue, 25 Aug 1998 16:54:49 +0200
Message-ID: <35E2D039.B153D99_at_fs-edv.de>
[Quoted] 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:
- Have i done something wrong or is this a bug (dbms or forms) ?
- 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) ?
Thanks in advance
Arnold Received on Tue Aug 25 1998 - 16:54:49 CEST