Encounter DRG-11207 Error While Executing CTX_DOC.Policy_Filter for Oracle Text (Doc ID 829163.1)

Last updated on OCTOBER 13, 2015

Applies to:

Oracle Text - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]
HP-UX PA-RISC (64-bit)
Oracle Solaris on SPARC (64-bit)
HP-UX Itanium
Linux x86-64
***Checked for relevance on 06-Sep-2012***

Symptoms

When attempting to create a POLICY_FILTER with FILTER => 'CTXSYS.AUTO_FILTER' and then using the policy_filter on an RTF document, this fails with DRG-11207

SQL> declare
  l_clob clob;
  begin
  for x in
 (select DOC_rtf_BLOB from TEST_BLOB_TABLE)
  loop
   ctx_doc.policy_filter(policy_name => 'my_policy',
                         document => x.DOC_rtf_BLOB,
                         restab => l_clob,
                         plaintext => FALSE,
                         charset => 'US7ASCII');
      INSERT INTO TEST_CLOB_TABLE values ( l_clob ) ;
end loop;
end;
/
declare
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-11207: user filter command exited with status 1
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DOC", line 1011
ORA-06512: at line 7


Another symptom can be the ctxhx standalone execution failure:

> $ORACLE_HOME/ctx/bin/ctxhx test.doc test.html
> echo $?
1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms