ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Stored procedures (package functions) returning a row
Date Fri, 06 Oct 2006 14:01:09 GMT
Sorry, I haven't been following this thread that closely, but why not
use out parameters?

Larry


On 10/6/06, C.Zecca@ads.it <C.Zecca@ads.it> wrote:
>
>
> 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