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!

UTL_FILE fopen - Blob to File System (Dynamic Directories)

Sohilkumar BhavsarJul 17 2010 — edited Jul 20 2010

Hi,

I am uploading blob content to file-system using UTL_FILE.fopen.

I am uploading files as:

Base_Directory/2010/07/17/myfile.ext

1. Now my question is that do I need to

i. create oracle directory
ii. grant read, write rights
iii. after uploading delete oracle directory

2. Another way is to use Java Class.

I know above steps.

I want to know that is there any other way

such as I will create only a single oracle directory and I can upload files in any child directory?

What is the best solution?

Regards,

Sohil Bhavsar.

This post has been answered by Billy Verreynne on Jul 20 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2010

Added on Jul 17 2010

#database, #pl-sql, #plsql, #sql

12 comments

3,575 views