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 AUGUST 18, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
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.REGION.EXAMPLE.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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |