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

jobs schrieb:
> 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.
>

 From what you provided, you have a typo: emi_ouput - declared
emi_output - referred

Best regards

Maxim Received on Mon Apr 30 2007 - 16:38:44 CDT