开发者

Insert data into bfile column

开发者 https://www.devze.com 2023-03-08 10:46 出处:网络
Hi I am trying to insert data into a bfile column with below code: 1.) CREATE OR REPLACE DIRECTORY STUFF

Hi I am trying to insert data into a bfile column with below code:

1.) CREATE OR REPLACE DIRECTORY
STUFF
AS
'D:/Dev/stuff';

2.) create table temp_bfile
(
bfile_loc    BFILE
);

3.)insert into temp_bfile(bf开发者_StackOverflow社区ile_loc) values (BFILENAME('STUFF', 'WD.pdf'));

4.) select * from temp_bfile;

The fourth block of code throws me this error:

ORA-00932: inconsistent datatypes: expected NUMBER got FILE 

What I am missing here ? Using Oracle 10g XE on windows 7


You need the 11g (or 11gr2) client to display BLOB / BFILE

0

精彩评论

暂无评论...
验证码 换一张
取 消