Top
Symfoware Server V12.1.0 Application Development Guide
FUJITSU Software

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.