我用EF做的,想在再做多数据库支持,可是做到oracle的时候会报这个错误,字段类型都是和数据库一样的,是有的字段是lob类型的么,哪个大神帮我解答,坐等!
------解决方案--------------------
oracle lob类型的处理机制缺失和其他数据库不太一致
-- 保存lob到表
CREATE OR REPLACE PROCEDURE "LOB_INSERT" (file_name_ varchar2, file_data_ in out nocopy blob) as
begin
insert into files (file_name, file_data)
values (file_name_, empty_blob())
returning file_data into file_data_;
end;
-- 更新表中的lob
CREATE OR REPLACE PROCEDURE "LOB_UPDATE" (id_ number, file_name_ varchar2, file_data_ in out nocopy blob) as
begin
update files set file_name = file_name_ where id = id_;
select file_data into file_data_ from files where id = id_
for update nowait;
end;
-- 从表中获取lob
CREATE OR REPLACE PROCEDURE "LOB_SELECT" (id_ number, file_data_ in out nocopy blob) as
begin
select file_data into file_data_ from files where id = id_;
end;