ORA-21500: internal error code when trying to appendchildxml

Hi,

I'm using Version 12.0.7.1837 (64 bit).

When trying to use appendchildxml function I'm getting error:
[quote]
ORA-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s][/quote]
Following is a very simple exaple that also causes the error:

SQL Query

select appendchildxml(xmltype('<a><b><c>test1</c></b></a>'), '/a/b', xmlelement("c", null, 'test2')) from dual;

The same sql works fine on PLSQL Developer Version 11.0.6.1776

So it seems related to newer/64-bit version of application.

[EDIT:] Hi Marco, thanks for swift response - I've sent you the information via priv message

Can you start PL/SQL Developer, go to Help > Support Info and send me the text from the "Info" tab page?

We're looking into this. At the moment I can only suggest that you add the getclobval() function as a workaround:

select appendchildxml(...).getclobval() from dual

Didn't realize that the issue was with displaying xmltype value as other XMLs are returned fine.

Anyway getclobval() works fine as a workaround for me.
Thank you.