We upload files on our library on weekly basis. I wanted to fetch the latest uploaded file path/URL from a folder through PL/SQL, but not sure if it's possible.
If possible, please suggest what should I do.
-
windows/linux, what version of Oracle?– kevinskioCommented Oct 4, 2013 at 18:07
-
It's Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit– ChinmayCommented Oct 6, 2013 at 10:40
Add a comment
|
2 Answers
Mr. Kyte wrote about accessing os-file-information utilizing the preprocessor directive a while ago. Perhaps this is what you are after.
I don't think it is necessary to use those APIs to do OS related work. it is important to note the GAP between OS and DB, DB should focus on data while other OS related work should be handled by OS, so here I would suggest define the interface well and pass the necessary information into the interface through OS calls.
-
Why? The OP says there will be just one file per week. I would just make the latest file available as an external table by using the preprocessor (as suggested by @Bjarte) to create a simlink to the latest file and have the external table look at the simlink. Commented Oct 6, 2013 at 12:21