SSRS连Oracle SQL Developer 数据源, 数据集的查询语显示错误 ' expected CHAR got NUMBER'
0
数据库: ORACLE SQL DEVELOPER , 表IC_1218, 列IC_ID数据类型number
SSRS 查询语句:
select * from IC_1218
where IC_ID=to_number(COALESCE(:UserIDs, IC_ID))
或
select * from IC_1218
where IC_ID=to_char(COALESCE(:UserIDs, IC_ID))
或
select * from IC_1218
where IC_ID= COALESCE(:UserIDs, IC_ID)
参数: UserIDs 数据类型:Integer或 Text, allow null
无论怎样组合上述条件, 都显示错误: ORA-00932 inconsistent datatypes: expected CHAR got NUMBER
请大家给一点帮助,谢谢!
SSRS 查询语句:
select * from IC_1218
where IC_ID=to_number(COALESCE(:UserIDs, IC_ID))
或
select * from IC_1218
where IC_ID=to_char(COALESCE(:UserIDs, IC_ID))
或
select * from IC_1218
where IC_ID= COALESCE(:UserIDs, IC_ID)
参数: UserIDs 数据类型:Integer或 Text, allow null
无论怎样组合上述条件, 都显示错误: ORA-00932 inconsistent datatypes: expected CHAR got NUMBER
请大家给一点帮助,谢谢!
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
li052468 2015-12-28 回答
赞同来自: