troubleshooting Question

UTl_FILE invalid directory path error

Avatar of dplinnane
dplinnaneFlag for United States of America asked on
Oracle Database
20 Comments4 Solutions6282 ViewsLast Modified:
/* Formatted on 2005/01/25 19:45 (Formatter Plus v4.8.5) */
Not sure what is wrong with this?
Thx in advance using oracle 9i

ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 424
ORA-06512: at "ADMIN_QA.WRITE_FILE", line 5
ORA-06512: at line 3

CREATE OR REPLACE PROCEDURE write_file
IS
   l_file   UTL_FILE.file_type;
BEGIN
   l_file := UTL_FILE.fopen ('/tmp/outputfile/', 'testqa2_ora_14032_test1_binds_single_process.trc', 'w');
   UTL_FILE.put_line (l_file, 'this is a test');

   IF UTL_FILE.is_open (l_file)
   THEN
      UTL_FILE.fclose (l_file);
   END IF;
END;


ASKER CERTIFIED SOLUTION
jrb1
senior developer
Join our community to see this answer!
Unlock 4 Answers and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros