10.2.0.5 db - Invalid path ORA-29280: invalid directory path when using utl_file.fopen with physical
Hi All,
Running 10.2.0.5 database. Getting this error "-29280: invalid directory path" when I have two entries in utl_file_dir parameter, and when I use the physical path for utl_file.fopen . Need to know if it is a requirement in 10.2.05 that utl_file.fopen needs a Directory object instead of a physical path ?
set serveroutput on size 1000000;
DECLARE
file_location VARCHAR2(256) := '/usr/tmp';
file_name VARCHAR2(256) := 'utlfile1.lst';
file_text VARCHAR2(256) := 'THIS IS A TEST';
file_id UTL_FILE.file_type;
BEGIN
file_id := UTL_FILE.fopen(file_Location, file_name, 'W');
UTL_FILE.put_line(file_id, file_text);