Sorry, I haven't been following this thread that closely, but why not use out parameters?
Larry On 10/6/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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
