Q
Problem solve Get help with specific problems with your technologies, process and projects.

Pointing to local directory in PL/SQL procedure

Can I point to a local directory for the UTL_FILE_DIR in a PL/SQL procedure?

Can I point to a local directory for the UTL_FILE_DIR in the PL/SQL procedure as follows?
UTL_FILE_DIR = c:/temp
Thanks in advance!
You can point to the file system in a procedure by using dynamic SQL. Also the UTL_FILE_DIR init.ora parameter cannot be changed for a session. It can only be changed for the system. Below is an example of a procedure used to change the value of the UTL_FILE_DIR init.ora parameter:
          declare

          begin

                 execute immediate ('alter system 
set utl_file_dir=''d:oracleadmintest1udump'' 
scope = spfile');

          end;

Dig Deeper on Using Oracle PL-SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close