Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Function to escape xml chars?

Re: Function to escape xml chars?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 03 Feb 2004 22:22:54 +0100
Message-ID: <bvp2ru$3p0$1@news3.tilbu1.nb.home.nl>


php newbie wrote:

> 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?

HTF.escape_sc (for Special Characters)
The HTF.escape_url still is not correct, IMHO

If you prefer procedures instead of functions, take a look at HTP

-- 

Regards,
Frank van Bortel
Received on Tue Feb 03 2004 - 15:22:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US