Re: Function-based index on LOBs?

From: Mark Bole <makbo_at_pacbell.net>
Date: Wed, 29 Dec 2004 22:50:34 GMT
Message-ID: <_wGAd.4540$yV1.1401@newssvr14.news.prodigy.com>

Frank Foss wrote:

> fitzjarrell_at_cox.net wrote:
>

>> Frank Foss wrote:
>>
>>> fitzjarrell_at_cox.net wrote:
>>>
>>>> Frank Foss wrote:
>>>>
>>>>
>>>>> Oracle 9.2.0.4 on Win2000 Advanced Server
>>>>>
>>>>> I tried to find the info on Tahiti, but came up short on what
>>>>> Oracle-supplied functions can be used in function-based indexes.

[...]
>

 >> Use the DBMS_OBFUSCATION_TOOLKIT.MD5 function.  It requires an input
 >> and an output parmeter. the output being the checksum.  I believe it
 >> will work with your data. but test it before you go off into
 >> production.

>
> That function appears not to exist in the documentation for the
> DBMS_OBFUSCATION_TOOLKIT for 9i r2
> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_obtool.htm
>

It exists in 9i, try "desc dbms_obfuscation_toolkit". But as for documentation, it is missing as you state, but you can find it under the   10g documentation.

-Mark Bole Received on Wed Dec 29 2004 - 16:50:34 CST