Re: Read error using UTL_FILE

Giridhar wrote:
> Thanks Sybrand for your reply.
> I checked with our DBA and he confirmed that we are on 64 bit.
> Do we get such errors even if we are on 64 bit database?
> Details of our v$version is as follows, which also confirms we are on
> 64 Bit:
>
> Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
> PL/SQL Release 9.2.0.5.0 - Production
> CORE 9.2.0.6.0 Production
> TNS for Solaris: Version 9.2.0.5.0 - Production
> NLSRTL Version 9.2.0.5.0 - Production
>
> Please guide me further to avoid such errors in future.
>
> Thanks again.
> Giridhar Kodakalla

If you have already checked the obvious i.e. filename and directory names are valid and you have read/write access to the directory then make sure that there aren't any lines in the file that exceed the max linesize. When you do utl_file.fopen and do not specify the max linesize as the last parameter then it is 1000 bytes by default. You can specify any value between 1 and 32767.

Regards
/Rauf Received on Fri Jan 06 2006 - 05:13:47 CST