Load files from a directory using oracle utl package
Posted on 2008-06-09
On our server files gets created everday. One process creates a directory with todays date(YYYYMMDD) and puts some files in that directory. I would like read all files from this directory using utl package. I do know how to read a single file from a directory using utl package, but I would like read all files in that directory and load into a table. All files names are with timestamp. Basically, I want to browse the directory and read all fils from my pl sql code using utl package.
Can this be done? If yes, can some one provide me sample code please.