Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove ASCII Value from 0-31 from the text

StephenJun 10 2010 — edited Jun 11 2010
Hi All,

I am trying to create an xml using the xmltype function and for some reason it throwing a parsing error and finally I figured out that it is due to the data linl escape character (Ascii Character 16).

So i want to remove the ASCII values from 0-31 from my text before converting into XML. What is the best way to accomplish this task?

Thanks,
VJ
This post has been answered by fsitja on Jun 10 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2010
Added on Jun 10 2010
5 comments
1,908 views