Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
windows/linux, what version of Oracle? –  kevinsky Oct 4 '13 at 18:07
    
It's Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit –  Chinmay Oct 6 '13 at 10:40
add 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.

query the operating system

share|improve this answer
add comment

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.

share|improve this answer
    
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. –  Colin 't Hart Oct 6 '13 at 12:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.