Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 10g utl_file.fclose?? ... PLS-00201: identifier ""must be declared
jobs wrote:
> 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.
No it isn't ... now the issue is to figure out why it isn't.
Post your real code and include your version number to 3 decimal places.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Apr 30 2007 - 16:52:17 CDT