ORA-00932: inconsistent datatypes: expected BLOB got FILE
447579Jan 21 2008 — edited Jan 21 2008Hi,
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.