Hi all, i'm new to this forum and had a question. I'm writing Java stored procedures for Oracle 10g and had a question. Is there anyway a java stored procedure/function can return a collection that contains value objects that I created ?
Basically in the java stored procedure I want to execute the same query(with different parameters) inside a loop and create a collection of Value objects created from each ResultSet. How would I go about passing this back to the calling client ?