Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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?
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!