My Oracle Support Banner

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

Last updated on OCTOBER 06, 2023

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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