Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00932: inconsistent datatypes: expected BLOB got FILE

447579Jan 21 2008 — edited Jan 21 2008
Hi,
I'm developing a requirement where it's needed to load existing files onto the DB (10.2 over RHEL 4).

I've created a DB directory pointing where the files are going to be, but when I try to insert them, the following error is raised:
"ORA-00932: inconsistent datatypes: expected BLOB got FILE"

I thought it would be related to the file because I was trying with a txt, but then it happens also with pdf, gif, jpg, etc.

This is what i've done:
create directory CIS_FILES as '/u03/cis_files'; --The directory does exist.
grant read on directory CIS_FILES to cis_user; --The user does exist.

--This was for trials, but the file also exists.
insert into cis_files (id, file)
values (1,bfilename('CIS_FILES','16admin.gif'));

ERROR at line 1:
ORA-00932: inconsistent datatypes: expected BLOB got FILE

Could anyone give me a hint of what is going on?
Regards,
Max.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2008
Added on Jan 21 2008
2 comments
1,308 views