SQL 错误 [932] [42000]: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB

SELECT
    UserOrgPerm.FRuleExpr
FROM
    T_PM_UserOrgPerm USERORGPERM
WHERE
    (
        (
            (
                UserOrgPerm.FOwner = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F'
                AND UserOrgPerm.FOrgID = '11111111-1111-1111-1111-111111111111CCE7AED4'
            )
            AND UserOrgPerm.FPermItemID = '5118976f-00fd-1000-e000-0010c0a813dePERMITEM'
        )
        AND UserOrgPerm.FPermType = 10
    )
UNION  SELECT
    RolePerm.FRuleExpr
FROM
    T_PM_RolePerm ROLEPERM INNER JOIN T_PM_UserRoleOrg USERROLEORG
        ON UserRoleOrg.FRoleID = RolePerm.FRoleID
WHERE
    (
        (
            (
                UserRoleOrg.FUserID = '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F'
                AND(
                    1 = 1
                    OR UserRoleOrg.FOrgID = '11111111-1111-1111-1111-111111111111CCE7AED4'
                )
            )
            AND RolePerm.FPermItemID = '5118976f-00fd-1000-e000-0010c0a813dePERMITEM'
        )
        AND RolePerm.FPermType = 10
    )

blob字段不允许distinct、insert、update等操作。他是特殊的对象,其实数据库里纪录的只是一个类似指针的对象,就象一个视图的概念




版权声明:本文为hu00848原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。