Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to handle dynamic tables in spring?

 
surya murali
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic