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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 30 Apr 2007 23:37:12 +0200
Message-ID: <46366189$0$6104$426a34cc@news.free.fr>

"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 1177968911.476250.31620_at_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 Received on Mon Apr 30 2007 - 16:37:12 CDT