BFILE with Oracle 8i on Windows NT?

From: Rob Mitchell <rjmitchell_at_mediaone.net>
Date: Wed, 30 Jun 1999 23:38:41 -0400
Message-ID: <zrBe3.2000$kL2.140131_at_ndnws01.ne.mediaone.net>



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 Thu Jul 01 1999 - 05:38:41 CEST

Original text of this message