This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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?
It's not a secret anymore!