Export Image Or Blob File From Database To Folder/Directory.

###############    Execute The Following Java Source In Database   ##################

CREATE OR REPLACE JAVA SOURCE NAMED "BlobHandler" AS
    import java.lang.*;
    import java.sql.*;
    import oracle.sql.*;
    import java.io.*;

    public class BlobHandler
    {
      public static void ExportBlob(String myFile, BLOB myBlob) throws Exception
      {
        File binaryFile = new File(myFile);
        FileOutputStream outStream = new FileOutputStream(binaryFile);
        InputStream inStream = myBlob.getBinaryStream();

        int size = myBlob.getBufferSize();
        byte[] buffer = new byte[size];
        int length = -1;

        while ((length = inStream.read(buffer)) != -1)
        {
          outStream.write(buffer, 0, length);
          outStream.flush();
        }

        inStream.close();
        outStream.close();
      }

    };

####################   Create Procedure Using Java Source   ###########################

   CREATE OR REPLACE PROCEDURE EXPORT_IMAGE (p_file  IN  VARCHAR2,
                                             p_blob  IN  BLOB)
    AS LANGUAGE JAVA
    NAME 'BlobHandler.ExportBlob(java.lang.String, oracle.sql.BLOB)';

############# Given Permition The Following For Execute Java Source Code ###########

    DECLARE
     V_USER VARCHAR2(30) := 'RND'; -- USER NAME
    BEGIN
      DBMS_JAVA.grant_permission(V_USER, 'java.io.FilePermission', '<<ALL FILES>>', 'read ,write, execute, delete');
      DBMS_JAVA.grant_permission(V_USER, 'SYS:java.lang.RuntimePermission', 'writeFileDescriptor', '');
      DBMS_JAVA.grant_permission(V_USER, 'SYS:java.lang.RuntimePermission', 'readFileDescriptor', '');
    END;
    /

#########    Export Image Or BLOB File To Directory/Folder ################

DECLARE
CURSOR c1 IS
SELECT ID, PHATO
FROM TEST_IMAGE; 
   
BEGIN
FOR i IN c1 LOOP
  
 EXPORT_IMAGE('C:\IMG\'||i.ID||'.jpg',i.PHATO);
     
END LOOP;
END;
/