Re: Question regardin replacing the value in a column

"Thomas Kellerer" <IQEWDSUVEDDF_at_spammotel.com> wrote in message news:c414lh$2d9cmf$1_at_ID-13919.news.uni-berlin.de...
> On 26.03.2004 11:08 Douglas Hawthorne wrote:
> > Thomas,
> >
> > Since what the OP wants to do is to escape the standard XML characters,
I
> > suggest that a call to DBMS_XMLGEN.CONVERT() is more appropiate here.
See
> > p.85-7 of "9i Supplied PL/SQL Packages and Types Reference".
> >
> > SQL> SELECT dbms_xmlgen.convert('&<>') FROM dual;
> >
> > DBMS_XMLGEN.CONVERT('&<>')
> > ----------------------------------------------------------------
> >
> > &amp;&lt;&gt;
> >
>
> Douglas,
>
> AFAIK this is not available in 8i, and the OP stated that he was using 8i.
>
> With a version > 9 you are right, this package would be better.
>
> Thomas
>

Thomas,

My apologies. You are correct. The package does not exist in 8i.

Douglas Hawthorne Received on Fri Mar 26 2004 - 05:44:40 CST