EMPTY_CLOB() value appeared when analyzing the archivelog files using LogMiner tool

Dear all,

I was using logminer in order to analyze the archivelog files, the purpose is to find all SQL undo commands to recover all data that I got lost by a mistaken action of getting our application patched.

During analyzing the archivelog file, I was able to see all SQL undo commands. However, there is a column containing the value named "empty_clob()", that I expected this should be our data.

The expected result:

insert into "MY_DATA"."MY_DEVICE"("MY_DEVICE_SID","TEMPLATE_SID","MAC_ADDRESS","STATUS_CODE","STATION_SID","STATION_VERSION","PREVIOUS_MY_DEVICE_SID","NAME","MY_DEVICE_VERSION","ACTIVE_DATE_TIME","SETTINGS","USER_PROFILE") values ('1111111111','222222222','ABCD1234EF56','1',NULL,NULL,NULL,NULL,'1',TO_DATE('30-AUG-22', 'DD-MON-RR'),