UTL_FILE or JAVA.IO for file manipulations
389040Jul 25 2005 — edited Jul 28 2005I 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?