My Oracle Support Banner

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

Last updated on FEBRUARY 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


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




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

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