PL/SQL (MOSC)

MOSC Banner

empty lines are removed when extracting content from large XML

edited Mar 19, 2012 8:36AM in PL/SQL (MOSC) 1 comment
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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center