ORA-03113 Reported When Using CTX_DOC.SNIPPET, Not Replicating when using CTX_DOC.MARKUP (Doc ID 2967393.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Executing below query results in "ORA-03113: end-of-file on communication channel", getting session disconnected, no other errors.

------

declare

result VARCHAR2(32767) ;

begin

result := CTX_DOC.snippet(index_name => '<SCHEMA_NAME>.<INDEX_NAME>, 

textkey => '5429',

text_query => '<TEXT>',

starttag => '<A NAME=ctx%CURNUM><i><b style="color:red; background:yellow">',

endtag => '</b></i></a>');

end;

[Error] Execution (11: 18): ORA-03113: end-of-file on communication channel

Process ID: 2121157

Session ID: 5518 Serial number: 16573

------

Following variation working fine:

decare

mklob clob;

BEGIN

CTX_DOC.markup(index_name => '<SCHEMA_NAME>.<INDEX_NAME>', 

textkey => '5429',

text_query => '<TEXT>',

restab => mklob,

plaintext => FALSE,

tagset => 'HTML_NAVIGATE',

starttag => '<A NAME=ctx%CURNUM><i><b style="color:red; background:yellow">',

endtag => '</b></i></a>');

END;

Changes

 None. This was a new implementation.

Cause

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