[size=medium] [b]执行如下sql会报错[/b]:
[color=red]ORA-00932: 不一致的数据类型: 要求 - 得到的却是 BLOB [/color]
select distinct (docs.id),
docs.title,
docs.documentNo,
docs.dispatchState,
docs.dispatchDate,
docs.dispatchUnit,
docs.theme,
docs.secretDegree,
[color=red] docs.contents,[/color]
docs.urgentDegree,
docs.synchroDocs,
docs.attachFiles,
docs.fullPinyin,
docs.simplePinyin,
docs.createUser,
docs.updateUser,
docs.updateDate,
docs.createDate,
docs.signstate
from (select doc.*, docHasOrg.Signstate
from documents doc, documentsHasOrg docHasOrg
where doc.id = docHasOrg.documentId) docs
[b]原因是:[/b]
[color=red]blob字段不允许distinct、insert、update等操作。他是特殊的对象,其实数据库里纪录的只是一个类似指针的对象,就象一个视图的概念[/color]
[b]表结构如下:[/b]
[img]http://dl.iteye.com/upload/attachment/0079/3021/a25dbdf4-287c-3ab0-8244-85ac1e2b8eb7.jpg[/img]
[/size]
[color=red]ORA-00932: 不一致的数据类型: 要求 - 得到的却是 BLOB [/color]
select distinct (docs.id),
docs.title,
docs.documentNo,
docs.dispatchState,
docs.dispatchDate,
docs.dispatchUnit,
docs.theme,
docs.secretDegree,
[color=red] docs.contents,[/color]
docs.urgentDegree,
docs.synchroDocs,
docs.attachFiles,
docs.fullPinyin,
docs.simplePinyin,
docs.createUser,
docs.updateUser,
docs.updateDate,
docs.createDate,
docs.signstate
from (select doc.*, docHasOrg.Signstate
from documents doc, documentsHasOrg docHasOrg
where doc.id = docHasOrg.documentId) docs
[b]原因是:[/b]
[color=red]blob字段不允许distinct、insert、update等操作。他是特殊的对象,其实数据库里纪录的只是一个类似指针的对象,就象一个视图的概念[/color]
[b]表结构如下:[/b]
[img]http://dl.iteye.com/upload/attachment/0079/3021/a25dbdf4-287c-3ab0-8244-85ac1e2b8eb7.jpg[/img]
[/size]