Working with BFILEsThe DBMS_LOB.FILEEXISTS functionExceptionsRestrictionsExamplesThe DBMS_LOB.FILEGETNAME procedureExceptionsExamplesThe DBMS_LOB.FILEOPEN procedureExceptionsExamplesThe DBMS_LOB.FILEISOPEN functionExceptionsRestrictionsExamplesThe DBMS_LOB.FILECLOSE procedureExceptionsExamplesThe DBMS_LOB.FILECLOSEALL procedureExceptionsExamplesThe DBMS_LOB.LOADFROMFILE procedureExceptionsExamplesReading and Examining LOBsThe DBMS_LOB.COMPARE functionExceptionsRestrictionsExamplesThe DBMS_LOB.GETLENGTH functionRestrictionsExamplesThe DBMS_LOB.READ procedureExceptionsExamplesThe DBMS_LOB.SUBSTR functionExceptionsRestrictionsExamplesThe DBMS_LOB.INSTR functionExceptionsRestrictionsExampleUpdating BLOBs, CLOBs, and NCLOBsThe DBMS_LOB.APPEND procedureExceptionsExamplesThe DBMS_LOB.COPY procedureExceptionsExampleThe DBMS_LOB.ERASE procedureExceptionsExampleThe DBMS_LOB.TRIM procedureExceptionsExampleThe DBMS_LOB.WRITE procedureExceptionsExample