PL/SQL (MOSC)

MOSC Banner

10.2.0.5 db - Invalid path ORA-29280: invalid directory path when using utl_file.fopen with physical

edited Sep 5, 2014 3:57PM in PL/SQL (MOSC) 6 commentsAnswered ✓

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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center