how to pass a resultset object in a function

[MuraliH Krishna]

Hai Ranchers,
I have a requirment of passing a resultset object to a function. When I try to access the resultset object in the receiving end, I am getting an error like closed resultset cannot be accessed. I can understand that we pass a reference to the calling function but is there a way to pass the resultset object and its data.Can some one help me please. its very urgent.

[Jimmy Clark]

It is better to copy the data from the ResultSet into a Collection class. You can then pass a reference to this Collection class to the function.

[Jeanne Boyarsky]

James is correct. It is better design for the ResultSet object to stay in the database layer.