Java Database Connectivity (JDBC)

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 or JAVA.IO for file manipulations

389040Jul 25 2005 — edited Jul 28 2005

I need to manipulate the files(CRUD operations).
I thought of storing the files as BFILES and accessing them using the DIRECTORY alias.
For that I can use UTL_FILE package(enhanced version of Oracle 91R2). Disadv. I see using UTL_FILE is restriction of the file size. Is there any other?

I am java prog. so i also have inclination towards using java.io FILE class as java stored procedures. Disadv I see is, I will have to provide platform specific full file name with path (like /user/test/dir/.....) for creating/removing files as compared to just specifying the Directory alias. Right? I don't see any documentation specifying the use of DIRECTORY with java.io File class.

My confusion is should I go for UTL_FILE or Java.io.File for manipulating the files. Which option is more beneficial?

Thanks for your suggestions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 25 2005

Added on Jul 25 2005

#java-database-connectivity-jdbc

3 comments

833 views