my storeprocedure will return a str

[raji96]

my storeprocedure will return a structure likethis
type student is record
(field1 varchar2(20),
field2 varchar2(20),
field3 varchar2(20),
field4 integer,
field5 varchar2(20),
);
type student_rec is table of student index by binary_integer;

how do get this in jdbc,i ran the storeprocedure and printed the output this structure has valuesin it,i need to call it from the jdbc,how do i do that.


thanks.

 

[LittleWing]

try the ResultSet.getRef() method.

check this out

http://java.sun.com/products/jdbc/articles/book.html

"It is now easier to store user-defined data types (UDTs) as column values. The two new SLQ3 UDTs are SQL structured types and DISTINCT types. (A structured type has multiple attributes, and you can think of a DISTINCT type as a structured type with only one attribute.) It is also possible to create an SQL REF type that references an instance of a structured type. An SQL structured type maps to the Struct interface, and an SQL REF maps to the Ref interface. A DISTINCT type is based on another data type, so it just maps to that data type. You store and retrieve Struc , Ref , and DISTINCT instances with set and get methods, just as with the other data types"