Error when trying to select xmltype column on Oracle 11.2.0.4
Client version Version 23.5.0.24.07
CREATE TABLE test_xml
(
id NUMBER (6),
xml SYS.XMLTYPE
)
INSERT INTO test_xml
VALUES (1, xmltype ('<test/>'));
COMMIT;
SELECT id FROM test_xml;
id
-----------
1
SELECT xml FROM test_xml;
**[Error] Execution (16: 6): ORA-03120: two-task conversion routine: integer overflow**
**Help: https://docs.oracle.com/error-help/db/ora-03120/**
On Oracle 19c there are no error
SqlPlus work fine:
SQL*Plus: Release 23.0.0.0.0 - Production on Fri Nov 22 11:35:55 2024
Version 23.5.0.24.07
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from test_xml;
ID
----------
XML
--------------------------------------------------------------------------------
1
<test/>
SQL>
