empty lines are removed when extracting content from large XML
Hi,
I'm trying to retrieve text from a XML node in a large XML document, somehow empty lines are removed from the node's text content, if the XML isn't as big the content is returned with the empty lines.
I have tried several ways of extracting the content from the XML, but the result is always the same, it seems like Oracle is handling large XML differently to smaller XML.
Can anyone please tell me if there is a fix or a workaround for this problem
Thank you in Advance,
Erik Bruinsma
my test code:
declare
lv_response CLOB;
lv_part VARCHAR2(32767);
I'm trying to retrieve text from a XML node in a large XML document, somehow empty lines are removed from the node's text content, if the XML isn't as big the content is returned with the empty lines.
I have tried several ways of extracting the content from the XML, but the result is always the same, it seems like Oracle is handling large XML differently to smaller XML.
Can anyone please tell me if there is a fix or a workaround for this problem
Thank you in Advance,
Erik Bruinsma
my test code:
declare
lv_response CLOB;
lv_part VARCHAR2(32767);
0