I am getting the error PLS-00306 wrong number or types of argument.Code:EXECUTE UTL_FILE.FOPEN('E:\DATA','ITEM.DAT','R');
UTL_FILE_DIR is set, the path and file name is aslo correct.
Any clue?
TIA
Printable View
I am getting the error PLS-00306 wrong number or types of argument.Code:EXECUTE UTL_FILE.FOPEN('E:\DATA','ITEM.DAT','R');
UTL_FILE_DIR is set, the path and file name is aslo correct.
Any clue?
TIA
Hi, you have to satisfy fhe return-type of fopen;
This is the handle which identifiy the file for other operations.
Orca
:cool:Code:UTL_FILE.FOPEN (
location IN VARCHAR2,
filename IN VARCHAR2,
open_mode IN VARCHAR2)
RETURN UTL_FILE.FILE_TYPE;