ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB
ah_baolong
2072次浏览
编辑于2016年03月08日 13:23:14
Sql execute exception : SELECT UserOrgPerm.FRuleExpr FROM T_PM_UserOrgPerm UserOrgPerm
WHERE UserOrgPerm.FOwner = ? AND UserOrgPerm.FOrgID = ? AND UserOrgPerm.FPermItemID = ? AND UserOrgPerm.FPermType = ? UNION SELECT RolePerm.FRuleExpr FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleIDWHERE UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ? AND RolePerm.FPermItemID = ? AND RolePerm.FPermType = ? Caused exception message is: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOBEAS703 的，打过补丁出现这个问题，求解！！！
WHERE UserOrgPerm.FOwner = ? AND UserOrgPerm.FOrgID = ? AND UserOrgPerm.FPermItemID = ? AND UserOrgPerm.FPermType = ? UNION SELECT RolePerm.FRuleExpr FROM T_PM_RolePerm RolePerm INNER JOIN T_PM_UserRoleOrg UserRoleOrg ON UserRoleOrg.FRoleID = RolePerm.FRoleIDWHERE UserRoleOrg.FUserID = ? AND UserRoleOrg.FOrgID = ? AND RolePerm.FPermItemID = ? AND RolePerm.FPermType = ? Caused exception message is: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOBEAS703 的，打过补丁出现这个问题，求解！！！
推荐阅读