is there a way we can mimic the dml error log behavior for table has clob column ??
I try to create my own error_log table but I still got the complain my test case
ORA-38904: DML error logging is not supported for LOB column "TXT"
create table tstClob(xid number, txt clob)
alter table tstclob add constraint tstclob_xid_lt_999 check ( xid <= 999 )
create table tstclob_errlog(
ORA_ERR_NUMBER$ NUMBER,
ORA_ERR_MESG$ VARCHAR2(2000),
ORA_ERR_ROWID$ ROWID,
ORA_ERR_OPTYP$ VARCHAR2(2),
ORA_ERR_TAG$ VARCHAR2(2000),
xid number,
txt clob
)
insert into tstClob(xid,txt)
select 1001 as a_xid,TO_CLOB ('LoveEarthSiva1001') as a_txt from dual
LOG ERRORS INTO tstclob_errlog (systimestamp) REJECT LIMIT UNLIMITED;