XML Database (MOSC)

MOSC Banner

Having Problem creating XML file from a clob, that size is larger than 32767

edited Apr 13, 2011 8:55AM in XML Database (MOSC) 2 commentsAnswered
 Hello,

   We are able to create a XML file that originates from a CLOB.  We try to write the file using UTL.FILE utility's .  There is a limit of 32767 per "line".   I found some code that was handling this for a  BLOB and  made changes to  apply to a CLOB.

  BUt the problem is,   when it breaks the file into  "chunks"  to write it,  it is  putting a  carrage return in the middle of  TAGS.   Is there any way around this,  or are we using the wrong method  to write the file.

Here is the procedure that i have to handle larger CLOB's,  but  the carriage return  is being written where we dont want it.

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