I have an XML having more than 2500 nodes, I want to update all the values using xquery statement.
I have written the sample PLSQL block here
https://livesql.oracle.com/apex/livesql/file/content_EM3I5LRDTVANV3XRO2GR7RAFM.html
This is working fine as far as number of nodes is less than or equal to 2426.
Once the number of node exceeds 2426, xmlupdate is giving this error message.
ORA-19112: error raised during evaluation:
XVM-00004: internal error "code buffer overflow"
0 declare default element namespace "http://www.mywrb.com/test/myspace";
(: - ^
ORA-06512: at line 38
ORA-06512: at "SYS.DBMS_SQL", line 1721
Is there any limitation in the xquery to update the nodes?