Ctx_query.hfeedback Generates Error DRG-00100 [50935],[drpn.c],[1130],[50601],[drlm.c],[293] (Doc ID 2124585.1)

Last updated on NOVEMBER 24, 2019

Applies to:

Symptoms

On : 11.2.0.4 version, Query on context index (contains)

 ctx_query.hfeedback generates error does not return results.

 ERROR
-----------------------
ORA-20000: Oracle Text error:
DRG-00100: internal error, arguments : [50935],[drpn.c],[1130],[],[]
DRG-00100: internal error, arguments : [50935],[drpn.c],[1492],[],[]
DRG-00100: internal error, arguments : [100],[drpn.c],[3362],[],[]
DRG-00100: internal error, arguments : [50601],[drlm.c],[293],[],[]

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_QUERY", line 433
ORA-06512: at line 2
20000. 00000 - "%s"
*Cause: The stored procedure 'raise_application_error'
  was called which causes this error to be generated.
*Action: Correct the problem as described in the error message or contact
  the application administrator or DBA for more information.

STEPS
-----------------------
Executing this ctx_query.hfeedback statement generates the error message below.
  BEGIN
  ctx_query.hfeedback (index_name => 'CI_HV_CLOBS',
  text_query => 'computer',
  feedback_table => 'restab',
  sharelevel => 0,
  feedback_id => 'query1'
  );
  END; >

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot use ctx_query.hfeedback.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.