开发者

Insert data into bfile column

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜