Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

OpenEdge 10.1B

SYMPTOM(s):

[DataDirect][OpenEdge JDBC Driver][OpenEdge] Array element value overflow. (12664)

Char array column test is defined with 2 extents and SQL-Width of 3

Executing the following query fails:
UPDATE PUB.Customer SET test1='aaa' where "Cust-Num"=1;
SELECT test1 FROM PUB.Customer where "Cust-Num"=1;

CAUSE:

Accessing a char field containing more characters than defined with SQL-Width via the SQL-92 engine.
In the specific case each column extent for the specific record was updated to contain 3 characters which are then in total 6 characters for the two extensions. The SQL-Width for the record selection of the individually extent was sufficient but not to select the whole array.

FIX:

Select each array column extent individually.
Example:
SELECT test1[1] FROM PUB.Customer where "Cust-Num"=1;
SELECT test1[2] FROM PUB.Customer where "Cust-Num"=1;