lcr$_row_record Method : get_row_text () Fails With Errors : ORA-21560: argument 'lob_stmt COPY FAILED' is null, invalid, or out of range (Doc ID 1298796.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The following DML handler to determine the sql associated with an LCR fails :

create or replace procedure mydml_handler(in_any in anydata)
is
lcr sys.lcr$_row_record;
v_sqltext clob;
rc number;
begin
v_sqltext:=empty_clob();
rc := in_any.getobject(lcr);
lcr.get_row_text(v_sqltext);
insert into mydml_tab
values (mydml_seq.nextval,v_sqltext);
end;
/

The error generated , refering to dba_apply_error, may be similar to the following :

APPLY_NAME QUEUE_NAME
------------------------------ ------------------------------
QUEUE_OWNER LOCAL_TRANSACTION_ID
------------------------------ ----------------------
SOURCE_DATABASE
--------------------------------------------------------------------------------
SOURCE_TRANSACTION_ID
--------------------------------------------------------------------------------
SOURCE_COMMIT_SCN MESSAGE_NUMBER ERROR_NUMBER
----------------- -------------- ------------
ERROR_MESSAGE
--------------------------------------------------------------------------------
RECIPIENT_ID RECIPIENT_NAME MESSAGE_COUNT ERROR_CRE
------------ ------------------------------ ------------- ---------
SOURCE_COMMIT_POSITION
--------------------------------------------------------------------------------
ERROR_TYPE
-----------
STRMADMIN_APPLYU1 STREAMS_QUEUEU1
STRMADMIN 10.33.9603
STRM11.US.ORACLE.COM
1.10.679
7274646 1 21560
ORA-21560: argument 'lob_stmt COPY FAILED' is null, invalid, or out of range
ORA-06512: at "SYS.LCR$_ROW_RECORD", line 577
ORA-06512: at "STRMADMIN.MYDML_HANDLER", line 8
ORA-06512: at line 1
105 U1 1 24-FEB-11
0000006F009600000001000000010000006F0096000000010000000101

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