B.6.1 Registering a Directory to Load and Write Text Files

Oracle database

[Oracle9i or earlier]
Configure the following with initialization parameter
   UTL_FILE_DIR='/home/symfo' ...(1)

[Oracle9.2i or later]
   Configure the following with CREATE DIRECTORY statement
   CREATE DIRECTORY DIR AS '/home/symfo'; ...(1)

Symfoware Server

INSERT INTO UTL_FILE.UTL_FILE_DIR(dir)
       VALUES('/home/symfo'); ...(1)

(1) UTL_FILE_DIR/CREATE DIRECTORY

Feature differences

Oracle database: Configure the directory to be operated, using the CREATE DIRECTORY statement or the initialization parameter UTL_FILE_DIR.

Symfoware Server: The directory to be operated cannot be configured using the CREATE DIRECTORY statement or the initialization parameter UTL_FILE_DIR.

Conversion procedure

Configure the target directory information in the UTL_FILE.UTL_FILE_DIR table using the INSERT statement. Note that this conversion procedure should be performed only once before executing the PL/pgSQL function.

When using the initialization parameter UTL_FILE_DIR:
1. Check the initialization parameter UTL_FILE_DIR value ('/home/symfo' in the example).
2. Using the INSERT statement, specify and execute the directory name checked in step 1.
  - Specify UTL_FILE.UTL_FILE_DIR(dir) for the INTO clause.
  - Using the character string literal ('/home/symfo' in the example), specify the target directory name for the VALUES clause.
  - If multiple directories are specified, execute the INSERT statement for each directory.
When using the CREATE DIRECTORY statement:
1. Check the directory name ('/home/symfo' in the example) registered with the CREATE DIRECTORY statement. To check, log in SQL*Plus as a user with DBA privileges, and execute "show ALL_DIRECTORIES;".
2. Using the INSERT statement, specify and execute the directory name checked in step 1. Same steps are used to specify the INSERT statement as when using the initialization parameter UTL_FILE_DIR.