Pointing to local directory in 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!

    Requires Free Membership to View

    Login

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;

This was first published in July 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top