ORA-00932: 不一致的数据类型: 要求 - 得到的却是 BLOB

[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]