Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

replace UTL_FILE with other utility

xzhang9
Occasional Contributor

replace UTL_FILE with other utility

Hi All,

We are in the process of a database consolidation project, we want all the apps and users to access our db server via database connections ONLY.

We have some java apps calling some PL/SQL stored procedures which use UTL_FILE to read and write files to our database server file system.

We need to replace the UTL_FILE usage with other programs to eliminate db server file system access.

Could you point out what other utilities or even java stored procedures to replace UTL_FILE and allow use to continue to write out files to network share drive?

Thanks,

Jane

2 REPLIES
Yogeeraj_1
Honored Contributor

Re: replace UTL_FILE with other utility

hi Jane,

It is more a database level question and has nothing to do with the underlying operating system. Which version Oracle are you using?

Technologies coming to my mind right now are: External Tables and WEBDAV.


kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Stoner
Occasional Visitor

Re: replace UTL_FILE with other utility

As he said, this is a question of design and database system.

If you absolutely have to remove file-system access you have to move the files into the database. Store them as BLOB/CLOB/XML documents. Chosen design is depending on what kinda files and the use of them.

If this is Oracle9 or newer you should atleast remove UTL_FILE and start using DIRECTORY. UTL_FILE is not recommended due to security issues. With DIRECTORY you can give separate oracle-users different rights on the directories(READ/WRITE).
Nobody told me it couldn't be done