Re: Question regardin replacing the value in a column

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 26 Mar 2004 13:12:04 +0100
Message-ID: <c416i6$sb4$1@news1.tilbu1.nb.home.nl>

Douglas Hawthorne wrote:

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

But the OWA packages do. And they have the same functionality on board somewhere.

-- 

Regards,
Frank van Bortel

Received on Fri Mar 26 2004 - 06:12:04 CST