Help with UTL_FILE under 7.3.2?

From: Dr. John B. Matthews <jmatthews_at_nova.wright.edu>
Date: 1997/10/04
Message-ID: <1997Oct4.132608_at_nova.wright.edu>#1/1

Hi!

[Quoted] [Quoted] I'm trying to use the package UTL_FILE to write to an OS file [Quoted] [Quoted] under Oracle 7.3.2 on Solaris. Sadly the code below dies with an invalid_path exception. Can anyone offer a clue?

News or email is fine; thanks in advance.

John

---

John B. Matthews, M.D.
jmatthews_at_nova.wright.edu, john_matthews_at_ccmail.dayton.saic.com "Whom the gods would destroy, they first invite to program in C"

---

     PROCEDURE    ftest IS
     
       f utl_file.file_type;
     
     BEGIN
     
       f := utl_file.fopen(
         '/oracle/app/oracle/product/7.3.2','ftest.txt', 'w');
       utl_file.put_line(f, 'Hello world!');
       utl_file.fclose(f);
     
     EXCEPTION
       WHEN utl_file.invalid_path THEN
         DBMS_Output.Put_Line('Invalid path.');
       WHEN utl_file.invalid_mode THEN
         DBMS_Output.Put_Line('Invalid mode.');
       WHEN utl_file.invalid_operation THEN
         DBMS_Output.Put_Line('Invalid operation.');
       WHEN OTHERS THEN
         DBMS_Output.Put_Line(SQLCODE||': '||SQLERRM);
     
     END;

Received on Sat Oct 04 1997 - 00:00:00 CEST