Hi,
I'm calling one storeproc that SP return type is defined as " o_statbl OUT qry_ssu_pkg.RTBL".
in package mentioned like "TYPE RTBL IS TABLE OF T1 INDEX BY BINARY_INTEGER;
TYPE T1 IS RECORD of some columns.
In my code i declared parameter like
declareParameter(new SqlOutParameter(o_statbl, OracleTypes.STRUCT,"qry_ssu_pkg.RTBL",new TableHandler()));
final class TableHandler implements SqlReturnType
{
public Object getTypeValue(CallableStatement cs, int row, int arg2,
String arg3) throws SQLException {
}
getting exception :
nested exception is java.sql.SQLException: invalid name
pattern: qry_ssu_pkg.RTBL
I tryed by given OracleTypes.ARRY ,OracleTypes.PLSQL_INDEX_TABLE getting same exception .
Could you please help me how to process this type of OUT parameters in spring?
