This content has been marked as final. Show 3 replies
UTL_FILE provides file access both on the client side and on the server side. When run on the server, UTL_FILE provides access to all operating system files that are accessible from the server. On the client side, as in the case for Forms applications, UTL_FILE provides access to operating system files that are accessible from the client.[url http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5007.htm#SQLRF01207]CREATE DIRECTORY
You must have CREATE ANY DIRECTORY system privilege to create directories.SQL*Plus runs server side so you cannot use utl_file to write files to your local drive unless the server itself can see your local drive.
What is your goal for this?
I make a bat file that permit to connect to db from cmd and launches sql script but i don't like that.I want use utl_file from client but i have problem with path. What do i (step) for for do that?
And if you have alredy used clob2file it's possibile use this function from client side.
Edited by: user11688764 on 18-mag-2012 13.01
In regards to clob2file, the second parm is a DIRECTORY name, as far as I know. This means the DB can only write to locations the machine running the DB has network access to.
Why do you feel you need to use utl_file for whatever purpose you need?