chandukb
asked on
Load files from a directory using oracle utl package
Hi,
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.
Oracle 10G
Thank You
cm
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.
Oracle 10G
Thank You
cm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER