Oracle UTL_FILE
From: <parthur_at_my-deja.com>
Date: 2000/05/10
Message-ID: <8fbube$6pc$1_at_nnrp1.deja.com>#1/1
4/1 PLS-00306: wrong number or types of arguments in call to 'FOPEN'
4/1 PL/SQL: Statement ignored
Date: 2000/05/10
Message-ID: <8fbube$6pc$1_at_nnrp1.deja.com>#1/1
[Quoted] [Quoted] 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 Wed May 10 2000 - 00:00:00 CEST