Ask the Expert

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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: