BFILE with Oracle 8i on Windows NT?

Hello,

Can anyone get BFILEs to work on Oracle 8i with Windows NT?

SQL> create directory my_dir for 'c:/temp';

OK

SQL> declare
  osFile BFILE := BFILENAME('my_dir', 'doc1.txt');   rc INTEGER;
begin

   rc := dbms_lob.FILEEXISTS( osFile );   if (rc > 1)
    dbms_output.put_line ('yes');
  else
    dbms_output.put_line ('no');
  end if;
end;

---
Rob Mitchell
rjmitchell_at_mediaone.net
Base Class Technologies, Inc. Received on Wed Jun 30 1999 - 22:38:11 CDT