top of page

Get Filenames from an Oracle Directory in IFS

  • Writer: Rumesh Aponso (RMAX)
    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


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page