Re: Oracle UTL_FILE

like the error message says, you have the wrong number of args for the fopen function. FOPEN requires 3 args, the directory, the file and the mode. the directory must be specified in the init<sid>.ora file

/Kel

parthur_at_my-deja.com wrote:

> I am currently using DBMS_OUTPUT, but need to switch to UTL_FILE.
> However it is not clear the necessary syntax. The following is what I
> get back.
> SQL> CREATE OR REPLACE PROCEDURE redi.TestFileIO
> 2 AS
> 3 BEGIN
> 4 UTL_FILE.FOPEN('/log/file1.log','w');
> 5 UTL_FILE.FCLOSE_ALL;
> 6 END;
> 7 /
> Warning: Procedure created with compilation errors.
> SQL> show errors
> Errors for PROCEDURE REDI.TESTFILEIO:
> LINE/COL ERROR
> -----------------------------------------------------------------
> 4/1 PLS-00306: wrong number or types of arguments in call to
> 'FOPEN'
> 4/1 PL/SQL: Statement ignored
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu May 11 2000 - 00:00:00 CEST