Re: Question regardin replacing the value in a column

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 Received on Fri Mar 26 2004 - 05:37:27 CST