Problem with CONTAINS function in 10g Options

[shahul]

Hi All,

I have the following query used in a package procedure. This package gets compiled in 8i. Now the database has been migrated to 10g using export and import. In 10g the package compilation fails. The error is at the CONTAINS function. Error says it is an invalid identifier.

Is CONTAINS deprecated in 10g? Is there any other alternative for CONTAINS? your help is highly appreciated.

select ISH.IND#ID,ISH.DATA,nvl(score(10),0)
from INDIV_SEARCH ISH,SANCTIONS SCN
where ISH.PARTITION_KEY = decode(p_partition_key,0, ISH.PARTITION_KEY,p_partition_key)
and contains( SCN.TEXT, replace_search_terms (ISH.DATA), 10) >= 0;

[burleson]

Hi,

>> The error is at the CONTAINS function. Error says it is an invalid identifier.

Have you created the required Oracle*Text index?

The "contains clause" is alive and well, and I have my notes here:

http://www.dba-oracle.com/t_sql_contains_clause.htm