Utl_file.fopen

[SANJAY_G]

EXECUTE UTL_FILE.FOPEN('E:\DATA','ITEM.DAT','R');

I am getting the error PLS-00306 wrong number or types of argument.
UTL_FILE_DIR is set, the path and file name is aslo correct.
Any clue?

TIA

[Orca777]

Hi, you have to satisfy fhe return-type of fopen;
This is the handle which identifiy the file for other operations.

Orca

UTL_FILE.FOPEN (
location IN VARCHAR2,
filename IN VARCHAR2,
open_mode IN VARCHAR2)
RETURN UTL_FILE.FILE_TYPE;