DECLARE
    oNew         BLOB;
    oBFile       BFILE;
    v_path       VARCHAR2 (100) := 'EXT_DIR_TEST';
    v_fileName   VARCHAR2 (4000) := '';
BEGIN
    oBFile := BFILENAME (v_path, 'BlobFiles'); -- BlobFiles is the name of the folder I try to insert 
    DBMS_LOB.OPEN (oBFile, DBMS_LOB.LOB_READONLY);
    DBMS_LOB.createtemporary (oNew, TRUE);
    DBMS_LOB.LOADFROMFILE (oNew, oBFile, DBMS_LOB.lobmaxsize);
    DBMS_LOB.CLOSE (oBFile);
    INSERT INTO HR_FOLDER_INSERT  VALUES ( oNew );
    COMMIT;
    DBMS_LOB.freetemporary (oNew);
END;

  DECLARE
      oNew     BLOB;
      oBFile   BFILE;
      v_path varchar2(100) :='TOKS_HR_DIR_EXT_HDL';
      v_fileName varchar2(4000) := '';
   BEGIN
      oBFile := BFILENAME(v_path,null);
      DBMS_LOB.OPEN(oBFile, DBMS_LOB.LOB_READONLY);
      DBMS_LOB.createtemporary(oNew,TRUE);
      DBMS_LOB.LOADFROMFILE(oNew, oBFile, dbms_lob.lobmaxsize);
      DBMS_LOB.CLOSE(oBFile);
      INSERT INTO TOKS_HR_ARCHIVOS2  VALUES ( oNew );
      dbms_lob.freetemporary(oNew);     
   END;

SYS> CREATE OR REPLACE PROCEDURE get_file_list (p_files VARCHAR2)
  2  IS
  3    l_null  varchar2(100) := NULL;
  4    l_files varchar2(100);
  5  BEGIN
  6    l_files := p_files;
  7    sys.dbms_backup_restore.searchfiles(l_files, l_null);
  8    FOR x IN (select fname_krbmsft fname from x$krbmsft) LOOP
  9      dbms_output.put_line(x.fname);
 10    END LOOP;
 11  END;
 12  /

Procedure created.

SYS> GRANT execute ON get_file_list TO Michel
  2  /

Grant succeeded.

SYS> conn michel/michel
Connected.
MICHEL> exec sys.get_file_list ('C:\TEMP\*.JPG')
C:\TEMP\Travel1.JPG
C:\TEMP\Travel2.JPG
C:\TEMP\Travel3.JPG
C:\TEMP\Travel4.JPG
C:\TEMP\Travel5.JPG

PL/SQL procedure successfully completed.

SQL> CREATE OR REPLACE DIRECTORY temp_dir AS 'C:\TEMP';

Directory created.

SQL> CREATE TABLE files (
  2    file_date VARCHAR2(15),
  3    file_time VARCHAR2(15),
  4    file_size VARCHAR2(15),
  5    file_name VARCHAR2(50)
  6    )
  7  ORGANIZATION EXTERNAL (
  8    TYPE ORACLE_LOADER
  9    DEFAULT DIRECTORY temp_dir
 10    ACCESS PARAMETERS (
 11      RECORDS DELIMITED BY NEWLINE
 12      NOBADFILE
 13      NOLOGFILE
 14      PREPROCESSOR temp_dir:'list_files.bat'
 15      FIELDS TERMINATED BY WHITESPACE
 16    )
 17   LOCATION ('files.lst')
 18  )
 19  REJECT LIMIT UNLIMITED
 20  /

Table created.

SQL> host type c:\temp\list_files.bat
@echo off
dir %~dp0\*.JPG

SQL> SELECT * FROM files WHERE file_name LIKE '%.JPG';
FILE_DATE       FILE_TIME       FILE_SIZE       FILE_NAME
--------------- --------------- --------------- --------------------------------------------------
02/04/2004      12:07           258ÿ767         Travel1.JPG
23/08/2004      17:55           374ÿ382         Travel2.JPG
23/08/2004      17:56           311ÿ217         Travel3.JPG
23/08/2004      17:56           201ÿ726         Travel4.JPG
23/08/2004      17:57           269ÿ047         Travel5.JPG

5 rows selected.