I am trying to use the LOG ERRORS INTO syntax to capture errors where there maybe file system mount not available. The error I get when doing
insert into table XYZ
select
X,Y,dbms_lob.getlength(BFILENAME('DIR',t1.filename) filesize
from table ABC
where filename is not null;
The error I get is
ORA-22288: file or LOB operation GETLENGTH failed No such file or directory ....
I know that the file exists as I can see and read the file at the OS command.
However, why does mnothing get written to the ERR$ table? Or are such errors not what the ERR$ table is meant for?