Re: Help with UTL_FILE under 7.3.2?

Modify your init$ORACLE_SID.ora file to include utl_file_dir parameter which specifies
directories that you can access.

Dr. John B. Matthews <jmatthews_at_nova.wright.edu> wrote in article <1997Oct4.132608_at_nova.wright.edu>...
> Hi!
>
> I'm trying to use the package UTL_FILE to write to an OS file
> 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 Mon Oct 06 1997 - 00:00:00 CEST