I don't know about  table of records, but you can send array of types as an
input parameter, but you must create specific typeHandler. That goes
something like this (for Oracle):

create or replace
TYPE "I_REZERVATION_TYPE" AS OBJECT
(
    ID_REZERVATION NUMBER,
      ID_BRANCH     NUMBER,
      I_AGN        VARCHAR2 (1 CHAR),
      NAP_AGN      VARCHAR2 (100 CHAR),
    CONSTRUCTOR FUNCTION I_REZERVATION_TYPE
         RETURN SELF AS RESULT);

create or replace
TYPE "I_REZERVATION_ARRAY" AS TABLE OF I_REZERVATION_TYPE;

 --------------------------------------------------------------------------- --------------------------------------------------------------------------- -

 --------------------------------------------------------------------------- --------------------------------------------------------------------------- -

         TypeHandler:

public void setParameter(PreparedStatement ps, int argNum,
Object passedValue, JdbcType jdbcType) throws SQLException {

Connection conn;

                // list of maps
                // every map contains type field names as a key and field
values as a value
List<LinkedHashMap<String,Object>> inParams =
(List<LinkedHashMap<String,Object>>) passedValue;

STRUCT[] structArray = new STRUCT[inParams.size()];
conn = ps.getConnection();
StructDescriptor structDesc = StructDescriptor.createDescriptor(
"I_REZERVATION_TYPE", conn);
ArrayDescriptor arrayDesc = ArrayDescriptor.createDescriptor(
"I_REZERVATION_ARRAY", conn);

int valueCounter = 0;
for (Map<String, Object> properties : inCollection) {

structArray[valueCounter] = new STRUCT(structDesc, conn, properties);
valueCounter++;

Map input parameter:procedure_call(#{listOfMaps,mode=IN,typeHandler=yourTypeHandler})
The downside of this approach is that you have to map all your properties
from pojos to the keys in map. Key values must correspond to database type
properties.
Also you will have to create special typehandler for every type from the
database (or you can wrap the List<Map>, arrayName, typeName in another
pojo and use one generic typehandler for all calls).

Dana srijeda, 3. listopada 2012. 03:55:06 UTC+2, korisnik grimmel97 napisao
je: