Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: 10g utl_file.fclose?? ... PLS-00201: identifier ""must be declared

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 30 Apr 2007 14:52:17 -0700
Message-ID: <1177969935.251135@bubbleator.drizzle.com>


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.org
Received on Mon Apr 30 2007 - 16:52:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US