how to invoke a pl/sql function from java, to return a table of element

Hi everybody,

as the title, i have a pl/sql funtion, like below:

type t_record is record (

...

);

type t_table is table of t_record;

function() return t_table is ...

Is there any way for java get to know this data type? so that in java code, we can do some thing like below or similiar:

resultset rt = callablestatement.getresultset()..

thank you. :)

darvei

[426 byte] By [darveia] at [2007-11-27 6:37:31]
# 1
Check out the meta data methods.
kdajania at 2007-7-12 18:05:57 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
thank you. :)
darveia at 2007-7-12 18:05:57 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...