Here is a summary about the issue we face today ORA-22813: operand value exceeds system limits when
We are migrating from Oracle 10.2.0.4.0 Windows Server to Oracle 11.2.0.3.0 on Linux. we are doing a non-regression test pf our business application and we found an issue related to xml.
FROM DUAL
/But we don’t what to do to correct the issue because the error code is meaningless.Do we have to change a database parameter or do we have to rewrite some xml queries?
-- load data in GT tables
BEGIN
pkg_operation.read_operation (p_operation => 'DFE3C70FFC606BE2E043B8DDA8C04860');
END;
/
SELECT pkg_xml_object.get_gt_op_settle_instr_stdaln ('DFE3C70FFDBA6BE2E043B8DDA8C04860', 0)
FROM DUAL
/But we don’t what to do to correct the issue because the error code is meaningless.Do we have to change a database parameter or do we have to rewrite some xml queries?
0