10g utl_file.fclose?? ... PLS-00201: identifier ""must be declared

utl_file.fclose(emi_output);

Compilation errors for PROCEDURE CAPUSER.SP_FEES_EMI

Error: PLS-00201: identifier 'EMI_OUTPUT' must be declared

...

it is defined? and am able to open and write to the file.

Where do I define it? This code worked fine in 9i

prior code contains:

emi_ouput UTL_FILE.FILE_TYPE;
and
emi_ouput := utl_file.fopen(dir_name,file_name,'w');

Thanks. Received on Mon Apr 30 2007 - 16:35:11 CDT