ORA-00600: [qmxtcCtxConvertstring], [2], [2] On dbms_xmlgen.convert() (Doc ID 435555.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Symptoms

ORA-600 [qmxtcCtxConvertString] when executing select dbms_xmlgen.convert('a & b', 1) from dual;

The top of the stack trace is:

qmxtcCtxConvertString <- spefcpfa <- spfmccallstd <- pextproc <- psdexsp

If a valid escape code is used for the ampersand then the query succeeds.

The problem is that updateXML() should accept text including non-escaped general entities, but due to this problem is does not. The error ORA-31067 'XML nodes must be updated with valid nodes and of the same type' may be reported as well or instead of this error.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.