Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

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
post Sep 10 2017, 07:34 AM
Post #1


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


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.
Go to the top of the page
+Quote Post
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