File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Spring and the fly likes how to handle dynamic tables in spring?  Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "how to handle dynamic tables in spring?  " Watch "how to handle dynamic tables in spring?  " New topic
Forums: Oracle/OAS Spring

how to handle dynamic tables in spring?

surya murali

Joined: Mar 13, 2013
Posts: 1

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?
Bill Gorder

Joined: Mar 07, 2010
Posts: 1682

Does this shed any light?

Also some stuff in the reference manual

Also you can have a look at this project for additional Oracle support

I am adding this to the Oracle forum for you in case someone there might be able to help you.

[How To Ask Questions][Read before you PM me]
I agree. Here's the link:
subject: how to handle dynamic tables in spring?
jQuery in Action, 3rd edition