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
