Archive for the ‘FILEGETNAME’ tag
A wrapper function to DBMS_LOB.FILEGETNAME procedure
It got tiresome writing the logic for getting a BFILE
file name. So, I wrote a wrapper function that lets you return the physical file name for any table. I did it by leveraging NDS against a dynamic anonymous PL/SQL block.