after updating to the newest dotConnect for Oracle, I get the following exception:
Unhandled Exception: Devart.Data.Oracle.OracleException: ORA-12899: value too large for column "RADIX"."ARTICLE_TEST"."ARTID" (actual: 56, maximum: 14)
It seems that the error happens after Devart.Data.Oracle Version="9.6.621". v.9.6.646 is the first version in which I get the error.
It happens allways If you have an out parameter with CHAR, which is used inside the package to write some value to the database
Code: Select all
PACKAGE BODY PACKTESTHP
IS
FUNCTION test
( artid OUT article_test.artid%TYPE)
RETURN NUMBER
IS
BEGIN
artid := getartid;
INSERT INTO ARTICLE_TEST
(ARTID)
VALUES (artid);
RETURN 1;
END;
FUNCTION getartid
RETURN CHAR
IS
v_tonerartid CHAR(14) := '00000000000001';
BEGIN
return v_tonerartid;
END;
END;