Get Filenames from an Oracle Directory in IFS
- Rumesh Aponso (RMAX)

- Nov 22, 2024
- 1 min read
DECLARE
directory_name_ CONSTANT all_directories.directory_name%TYPE := 'OUT_DIR';
file_ist_ Intface_File_Types := Intface_File_Types();
BEGIN
-- get file list
file_ist_ := Intface_Server_File_API.File_List(directory_name_);
FOR i IN 1..file_ist_.count LOOP
Dbms_Output.Put_Line(file_ist_(i).file_name);
END LOOP;
END;



Comments