AQ Propagation with CLOB data types Fails with ORA-22990 (Doc ID 827184.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms

AQ Propagation

The message payload contains a CLOB data type.

Issue is observed when propagating to any 11.1 database .

The issue is known to affect AIX platforms. It was not observed on Linux. 

Error reported from propagation job :

The following error is encountered by the propagation job :

ORA-22990: LOB locators cannot span transactions
ORA-02063: preceding line from <remote database>


Setting event : 22990 errorstack / level 3 on the 11.1  database :

 

alter system set events='22990 trace name errorstack level 3';
-- wait for the error to occur then disable futher trace files to be generated
alter system set events='22990 trace name context off';

indicates the stack at the point the ora-22990 error is raised is as follows :

-- Stack Trace ---
ksesec0 <- koklglfn <- koklwrite1 <- kpolob <- opiodr <- ttcpip <- opitsk

Note : Significantly :

1. a message appears in the remote queue with an empty clob field;

2. with each propagation attempt which results in ora-22990 , a message is enqueued in the destination
queue.

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