CTX_DOC.POLICY_LANGUAGES fails with Core dump when BASIC_LEXER is used (Doc ID 1615499.1)

Last updated on JANUARY 20, 2014

Applies to:

Oracle Text - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

On 12.1.0.1.0 with <Patch 16781727> installed ctx_doc.policy_languages fails with core dump.

SQL> declare
 2 the_lngs ctx_doc.language_tab;
 3 input_text varchar2(5000);
 4 begin
 5 input_text := 'this is english';
 6 ctx_doc.policy_languages('rv_policy_21', input_text, the_lngs);
 7
 8 for i in 1..the_lngs.count loop
 9 if the_lngs(i).score > 0 then
10 dbms_output.put_line('language=' || the_lngs(i).language || ',score=' || the_lngs(i).score);
11 end if;
12 end loop;
13 end;
14 /

ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 12605
Session ID: 208 Serial number: 925

SQL> begin
 2 testLanguageID(1);
 3 end;
 4 /

ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 12645
Session ID: 590 Serial number: 2991

Exception ORA-7445 is seen immediately in the Alert log.

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