Question

ibatis调存储过程报错

xml定义：
{call PA_CRM_YW.P_PRICING_OBJECT_P(?, ?, ?, ?, ?, ?, ?, ?)}
-------------------------------------------------- 报错： -- The error occurred in conf/ibatis/priceobj.xml. --- The error occurred while executing query procedure. --- Check the {call PA_CRM_YW.P_PRICING_OBJECT_P(?, ?, ?, ?, ?, ?, ?, ?)}. --- Check the output parameters (register output parameters failed). --- Cause: java.sql.SQLException: 无效的列类型: -99999999; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in conf/ibatis/priceobj.xml. --- The error occurred while executing query procedure. --- Check the {call PA_CRM_YW.P_PRICING_OBJECT_P(?, ?, ?, ?, ?, ?, ?, ?)}. --- Check the output parameters (register output parameters failed).

Answer 1

你的数据库里的字段要跟java 的字段匹配上

Answer 2

你传的 参数 跟你存储过程需要的参数不同。存储过程传参要一一对应的

Answer 3

参数类型不对吧