ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From C.Ze...@ads.it
Subject Re: Stored procedures (package functions) returning a row
Date Fri, 06 Oct 2006 12:57:31 GMT

Cesare Zecca/Minosse scritti il 02/10/2006 14:09:38

> The function
>
> function get_key_2
> return Tipo_Dato.t_PK;

> of the ut_Tipo_Dato package returns a row (specifically a row
> composed by a single value).

The Tipo_Dato.t_PK is defined as follows

   type t_PK is record
   ( tipo_dato_ID  number(10)
   );

I've written and successfully tested some cases where the data were
returned via return/output parameters using the number(10) basic SQL type.
The question now is: how to retrieve that row?
I tried to investigate some topics related to typeName and typeHandler,
but...

...but the answer is that:

   It is not feasible for Oracle JDBC drivers to support calling arguments
   or return values of the PL/SQL types TABLE (now known as indexed-by
   tables), RESULT SET, RECORD, or BOOLEAN
   http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#34_05
Mime
View raw message