PL/SQL (MOSC)

MOSC Banner

Here is a summary about the issue we face today ORA-22813: operand value exceeds system limits when

edited Jul 22, 2013 12:25AM in PL/SQL (MOSC) 6 commentsAnswered
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.

-- 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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center