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


	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. "jobs" <j@webdos.com> a crit dans le message de news: 1177968911.476250.31@u30g2000hsc.googlegroups.com... \| 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. \| Post the whole procedure. What you posted is useless. Regards Michel Cadot -----------------------------------------------Reply----------------------------------------------- jobs schrieb: - Hide quoted text - > 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 -----------------------------------------------Reply----------------------------------------------- - Hide quoted text - 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 damor@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org -----------------------------------------------Reply----------------------------------------------- > From what you provided, you have a typo: > emi_ouput - declared > emi_output - referred wow. sorry all. It bit my nose off. Thanks.

MS Dynamics CRM 3.0

Oracle Database

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