AQ Propagation with CLOB data types Fails with ORA-22990
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1]
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
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