Oracle Directory Object
Oracle offers two ways for a session to read or write operating system files. 1.Oracle directories 2. UTL_FILE package UTL_FILE package contains many PL/SQL procedures for manipulating directory objects. Operating system directories that can be accessed by UTL_FILE are only those listed in UTL_FILE_DIR instance parameter. This parameter default to NULL but can be set to any comma separated list as well as * (wildcard) which means any directory in operating system. SQL > SELECT NAME, VALUE FROM V$PARAMETER WHERE UPPER(NAME) = 'UTL_FILE_DIR' Result --------------------------------------------------------------------------------------------------- utl_file_dir NULL All the directories listed will be visible to all sessions. To give a value for UTL_FILE_DIR parameter file use the following command. SQL > sqlplus /...