Re: UTL_FILE - check for file existence?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 25 Jan 2001 13:58:15 GMT
Message-ID: <3A7030F7.52B0CAEA@edcmail.cr.usgs.gov>

> I have done this using the DBMS_LOB package. This package contains the
> function FILEEXISTS. Of course, you have to be on 8i for this, and it may
> require some rework to switch from UTL_FILE.

IIRC, the FILEEXISTS function in the DBMS_LOB package works only with BFILES. In that case, the BFILE pointer must previous be declared and stored in a BFILE column. Without a BFILE pointer, you can not use the FILEEXISTS function.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Thu Jan 25 2001 - 07:58:15 CST