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
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