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 220.127.116.11 to 18.104.22.168 [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.
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-02063: preceding line from <remote database>
Setting event : 22990 errorstack / level 3 on the 11.1 database :
-- 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
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