Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> UTL_FILE.PUT_LINE : problem with CRLF at the end of line, CRLF in the middle of XML tag corrupting entire XML file
sayampu
post Sep 10 2017, 07:34 AM
Post #1


Newbie
*

Group: Members
Posts: 3
Joined: 26-June 17
From: bangalore
Member No.: 52,043



Hi,

I have a problem with my procedure that creates XML file with huge data.

If the XML line(or Tag) is too big(> 32767 max buffer size), I split the buffer and create new buffer for the remaining characters in the line. End of the line, it is adding CRLF by default.

For example, I have XML tag like below.

<Tag some data.../&amp;gt;&amp;lt;Channel Number=&quot;3&quot; CurveTemplate=&quot;positive3&quot; /&amp;gt;&amp;lt;Channel
Number=&quot;4&quot; CurveTemplate=&quot;positive4&quot; /&amp;gt;&ampCRLF --end of the line
--New line
;lt;Channel Number=&quot;5&quot; CurveTemplate=&quot;positive5&quot; /&amp;gt;&amp;lt;/Well&amp;gt;&amp;lt;Well Position=&quot;64&quot;&amp;gt;&amp;lt;Channel Number=&quot; /> -- end of tag

Due to CRLF at the end of line my XML is not readable by our application. I tried many ways to remove CRLF but failed. Could you please help me to remove CRLF at the end of line.

OS : Windows
Oracle Version : 11.2.03



Thanks in advance.
sayampu
Go to the top of the page
 
+Quote Post
boobal_ganesan
post Sep 11 2017, 07:54 AM
Post #2


Advanced Member
***

Group: Members
Posts: 77
Joined: 6-June 16
From: India
Member No.: 51,370



Hello Sayampu,

What are the methods you've tried to replace the CRLF from the end of the line?

Did you try REGEXP_REPLACE for your scenario?


Thank you,
Boobal Ganesan


--------------------
Check out my new Advanced PL/SQL book here - http://www.rampant-books.com/book_1701_pls...initive_ref.htm
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd September 2017 - 05:29 PM