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)
Configure the directory to be operated, using the CREATE DIRECTORY statement or the initialization parameter UTL_FILE_DIR.
The directory to be operated cannot be configured using the CREATE DIRECTORY statement or the initialization parameter UTL_FILE_DIR.
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:
Check the initialization parameter UTL_FILE_DIR value ('/home/symfo' in the example).
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:
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;".
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.