Archive for the ‘dbms_lob’ 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.
Oracle Database LOBs In-depth
Last month I presented the Oracle Database LOBs In-depth at the Utah Oracle User’s Group (UTOUG) Training Days. You can find the slides and sample programs here. The presentation illustrates how the transaction context works and how to access, maintain, and manage LOBs.