Re: Error while using BFILEs

Have you check whether you have the access right to read the directory/file? If you are not the owner of the directory nor a DBA, you needed to be granted the read privilege on the directory in concern.

HTH John Chiu

Venu Jadcherla wrote:

> I created a BFILE using the BFILENAME method and I
> used the "CREATE DIRECTORY" to create a directory and
> pass it to the BFILENAME procedure. The file that I am referring
> to using a BFILE exists in that directory. I keep getting an error
> "file or directory not found" when I try to call the DBMS_LOB
> "fileopen" method. The directory is on the same machine as the
> oracle server and I am trying to access it from a client instance
> of the oracle server.
>
> Thanks in advance for your replies.
>
> Cheers,
> Venu
>
> venuj_at_mycfo.com
Received on Mon Sep 27 1999 - 21:35:57 CDT