Hi there,
How to get a result from output parameter(oracle cursor).
Below is my code and that is not work.
Does anyone can help me?
Oracle Stored Procedure:
CREATE OR REPLACE PROCEDURE getProducts
(
rs OUT SYS_REFCURSOR
)
IS
BEGIN
OPEN rs FOR
SELECT * FROM Products;
END getProducts;
Interface:
public interface ProductMapper
{
@Select("call getProducts(#{rs,mode=OUT,jdbcType=CURSOR})")
@Options(statementType = StatementType.CALLABLE)
List<Product> getProducts();
}
DAO:
public class ProductDAO
{
public List<Product> getProducts()
{
return mapper.getProducts(); // mapper is ProductMapper
}
}
Error Message:
### Error querying database.
Cause: org.apache.ibatis.reflection.ReflectionException:
Could not set property 'rs' of
'class org.apache.ibatis.reflection.MetaObject$NullObject' with value
'oracle.jdbc.driver.oracleresultseti...@13f210f'
Cause: org.apache.ibatis.reflection.ReflectionException:
There is no setter for property named 'rs' in 'class java.lang.Class'
Thanks,
Alex
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
