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
精彩评论