Forum Stats

  • 3,784,369 Users
  • 2,254,929 Discussions
  • 7,880,793 Comments

Discussions

DRG-10849 catsearch does not support functional invocation

kerberos5
kerberos5 Member Posts: 16
edited Aug 8, 2012 5:30AM in SQL & PL/SQL
I have this error message: DRG-10849 catsearch does not support functional invocation
this is my query:

SELECT *
FROM
(SELECT
/*+ FIRST_ROWS(50) */
NTQ.*,
ROWNUM RNUM1
FROM
(SELECT
/*+ INDEX(DL_TSD_DEFTR_CI) */
*
FROM ima_ol.DL_TSD_SITUATION s
WHERE (CATSEARCH(DEF_TRANS,'milano ',NULL)>0)
AND (s.FORECAST = 0)
AND (s.STATE IN (1,0,4))
AND (s.ARCH_STATE = 0)
ORDER BY s.VET_TS DESC
) NTQ
WHERE ROWNUM <=50
)
WHERE RNUM1 >=1

my oracle and system version:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for Solaris: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

have suggested that to solve the problem I should alter the statistics of the offending table to force to use this index how do I do?
thanks in advance

Answers

This discussion has been closed.