UTL_FILE.FOPEN function

From: Judy Munn <munn_at_hq.mag.aramark.com>
Date: 1997/03/14
Message-ID: <E71sLo.3J6_at_news.mag.aramark.com>#1/1


I am having trouble using the UTL_FILE.FOPEN function. I am trying to call it within a stored procedure as follows:

CREATE OR REPLACE PROCEDURE WRITE_TO_FILE AS    /*Declare variables */
MY_HANDLE UTL_FILE.FILE_TYPE;

DIR_NM     CHAR := 'C:\JUDY';
FILE_NM    CHAR := 'writefil.txt';
MODE_NM    CHAR := 'w';

BEGIN
   select SYS.UTL_FILE.FOPEN(DIR_NM, FILE_NM, MODE_NM) into MY_HANDLE from dual;    UTL_FILE.FCLOSE (MY_HANDLE);
END; I am getting the following errors:

Errors for PROCEDURE WRITE_TO_FILE:
LINE/COL ERROR


6/21     PLS-00425: in SQL, function argument and return types must be SQL type 
10/4     PL/SQL: SQL Statement ignored 

Any suggestions would be greately appreciated!

Thanks you.

  • Judy Munn
Received on Fri Mar 14 1997 - 00:00:00 CET

Original text of this message