This content has been marked as final. Show 2 replies
I'm not sure I follow fully. I don't have 22.214.171.124 to test against, but I do not encounter any issue with this simple example
I get the same thing on 126.96.36.199 as well.
Connected to Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 SQL> set serveroutput on; SQL> SQL> declare 2 pSearchParams_Tx CLOB; 3 vXmlDoc XMLTYPE; 4 begin 5 pSearchParams_Tx := '<phase/>'; 6 vXmlDoc := XMLTYPE(pSearchParams_Tx); 7 dbms_output.put_line('Done 1'); 8 pSearchParams_Tx := '<phase></phase>'; 9 vXmlDoc := XMLTYPE(pSearchParams_Tx); 10 dbms_output.put_line('Done 2'); 11 end; 12 / Done 1 Done 2 PL/SQL procedure successfully completed
Do you have a code example that demonstrates the error?
Thank you for your input. My test case was apparently too involved. The tag had an extra slash. The xml parser works with one or two tags when a null is present. Thank you, your test case was good.