Print Thread
ORA-21500: internal error code when trying to appendchildxml
#58461 10/18/18 07:53 AM
Joined: Oct 2018
Posts: 11
S
Sztefi Offline OP
Member
OP Offline
Member
S
Joined: Oct 2018
Posts: 11
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

Last edited by Sztefi; 10/18/18 09:14 AM.
Re: ORA-21500: internal error code when trying to appendchildxml
Sztefi #58463 10/18/18 08:25 AM
Joined: Aug 1999
Posts: 21,172
Member
Offline
Member
Joined: Aug 1999
Posts: 21,172
Can you start PL/SQL Developer, go to Help > Support Info and send me the text from the "Info" tab page?


Marco Kalter
Allround Automations
Re: ORA-21500: internal error code when trying to appendchildxml
Marco Kalter #58469 10/18/18 02:16 PM
Joined: Aug 1999
Posts: 21,172
Member
Offline
Member
Joined: Aug 1999
Posts: 21,172
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


Marco Kalter
Allround Automations
Re: ORA-21500: internal error code when trying to appendchildxml
Marco Kalter #58488 10/19/18 11:31 AM
Joined: Oct 2018
Posts: 11
S
Sztefi Offline OP
Member
OP Offline
Member
S
Joined: Oct 2018
Posts: 11
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.

Last edited by Sztefi; 10/19/18 11:32 AM.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4