SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storing blob file content to windows shared folder in structured way

Pavan BadiJan 15 2018 — edited Jan 22 2018

How can I store oracle blob content file to windows shared folder in structured way. The detailed requirement is I am uploading some pdf,doc files to oracle database and storing in oracle BLOB column now I want to store those files into windows shared folder in structured way instead of BLOB content.

If I am Storing any file in Jan 2018 then it should store in "Company Name/2018/Jan/FileName1"

If I am storing any file in Feb 2018 then it should store in "Company Name/2018/Feb/FileName1"

The Current way I am trying is writing java class to OS operations and planning to pass all required parameters thought PLSQL but i am not getting how to pass blob to java class?

Thanks

Pavan

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2018

Added on Jan 15 2018

10 comments

1,213 views