Re: Function to escape xml chars?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 02 Feb 2004 16:16:41 GMT
Message-ID: <JJuTb.138$0_3.120@nwrddc01.gnilink.net>

"php newbie" <newtophp2000_at_yahoo.com> wrote in message news:124f428e.0402011121.4bd44b4d_at_posting.google.com...
> For a website, I generate XML files dynamically from an Oracle
> database. After retrieveing the data, I need to put them in the XML
> file. But if the selected columns contain XML special characters,
> this doesn't work.
>
> Is there a function in Oracle that would escape XML/HTML special
> characters?

You should have specified the Oracle version. Assuming its 9i:

SQL> select dbms_xmlgen.convert('<br>') from dual;

DBMS_XMLGEN.CONVERT('<BR>')

---

&lt;br&gt;

Anurag Received on Mon Feb 02 2004 - 10:16:41 CST