Oracle Text (MOSC)

MOSC Banner

DRG-10849 catsearch does not support functional invocation - after impdp

edited Dec 11, 2009 1:30AM in Oracle Text (MOSC) 6 commentsAnswered
Hi all,

I just imported a DB with impdp, I ran the health check script after that and all text indexes appeared like 'VALID' , now I'm testing a query from the application, the result were "catsearch does not support functional invocation". I appreciate any help.

----the query----

 SELECT b.cd_aut                                                   ,
Mostra_Campo(b.vl_cmp_aut_cmpaut,d.nm_parm_entd_cmpvfv)                 AS Campo ,  c.vl_cmp_aut_indaut                                                     AS Indice,
 Limpafrase(Mostra_Campo(b.vl_cmp_aut_cmpaut,d.nm_parm_entd_cmpvfv),1,0) AS Limpo ,
DECODE(SUBSTR(b.cd_cmp_aut,1,1),'1','A','4','R','7','E')                AS Icone ,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center