Can't FILEOPEN a BFILE

From: Eric Arnold <nospam_earnold_at_requisite.com>
Date: Thu, 11 Mar 1999 21:37:40 -0700
Message-ID: <7ca5mv$2jh$1@news1.rmi.net>

Hi. I was hoping somebody could point me in the right direction. I'm trying to get BFILEs to work for me. I know that file

U:\earnold\sql\category_item_desc\temp exists, but this fails:

create directory workdir as 'U:\earnold\sql\category_item_desc';

declare
bfile_var BFILE := BFILENAME( 'workdir', 'temp' ); begin
dbms_lob.fileopen( bfile_var, dbms_lob.file_readonly ); end;

ORA-22285: non-existent directory or file for FILEOPEN operation
ORA-06512: at "SYS.DBMS_LOB", line 370
ORA-06512: at line 4

Is there something special to know about how Oracle thinks about physical directories or file names?

Thanks,
-Eric

P.S. Please Cc: earnold_at_requisite.com Received on Thu Mar 11 1999 - 22:37:40 CST