BFile access problem

From: Martin Gutowski <gutowski_at_ed.ems.psu.edu>
Date: 27 Aug 2001 18:19:03 GMT
Message-ID: <9me2un$b2c$1@boatanchor.ems.psu.edu>

Hi,

I'm having trouble using BFiles on 8.1.7. Here's what I've done. Logged in as sys, I ran the following command:

SQL> create directory xmlfiles as 'c:\xmlfiles';

It worked as I received the message:

Directory created.

I then granted read access to me:

SQL> grant read on directory xmlfiles to gutowski; Grant succeeded.

I then logged in as gutowski, and ran:

SQL> select * from all_directories;

This worked also:

OWNER DIRECTORY_NAME DIRECTORY_PATH --------- -------------- -------------- SYS XMLFILES c:\xmlfiles

When I run the following command:

SQL> SELECT DBMS_LOB.getLength(BFileName('XMLFILES','claim77804.xml')) AS length FROM dual;

I get the error:

SELECT DBMS_LOB.getLength(BFileName('XMLFILES','claim77804.xml')) AS length FROM dual

*
ERROR at line 1:
ORA-22288: file or LOB operation GETLENGTH failed The system cannot find the file specified. ORA-06512: at "SYS.DBMS_LOB", line 518
ORA-06512: at line 1

Does anyone have any idea what's going on? The case is correct for the xml files, it's all lower on the file system--Windows NT 4.0.

Thanks,
Marty
gutowski_at_essc.psu.edu Received on Mon Aug 27 2001 - 13:19:03 CDT