identifier 'UTIL_FILE.FOPEN' must be declared, please help
DEAR ALL
I have a problem with util_file package . It is my first time to work with this package.
i create a simple procedure that make a text fileand write the word"new value " in it
i did the following:
CREATE OR REPLACE PROCEDURE P_CONVERT (P_LOCATION VARCHAR2,P_FILENAME VARCHAR2)IS
vfile utl_file.file_type;
BEGIN
Vfile := util_file.fopen(P_LOCATION,P_FILENAME,'a');
UTL_FILE.PUT (Vfile,'new value');
UTL_FILE.FCLOSE(Vfile);
END;
/
but the following error occure
PL/SQL: Statement ignored
PLS-00201: identifier 'UTIL_FILE.FOPEN' must be declared
please help