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,
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