Question

mybatis调用存储过程的时候，出现错误: 出现不支持的 SQL92 标记: 1:

### Error querying database. Cause: java.sql.SQLException: 出现不支持的 SQL92 标记: 1:
### The error may exist in com/basic/mapper/GoodsInfoMapper.xml
### The error may involve com.basic.mapper.GoodsInfoMapper.addObj-Inline
### The error occurred while setting parameters
### SQL: { call SP_ADDGOODSINFO( ?, ?, ?, ?, ?, ?, ?, ?, ? ) }
### Cause: java.sql.SQLException: 出现不支持的 SQL92 标记: 1:
; uncategorized SQLException for SQL []; SQL state [99999]; error code [17034]; 出现不支持的 SQL92 标记: 1: ; nested exception is java.sql.SQLException: 出现不支持的 SQL92 标记: 1:
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

Answer 1

Map<String, Object> param = new HashMap<String, Object>();
param.put("dname", "A");
//在这将一个游标类型传过去
param.put("depts", OracleTypes.CURSOR);