Stored procedure that return multiple records

I hope this is a correct group to discuss about my problem.

I need to create an Oracle stored procedure that could return multiple records (rows). This stored procedure will be execute by Java program. I understand that Java can do this. But I don't know how to do it.

I know that I could create a stored procedure that will write to a temporary table, then the Java program will just need to select from that table. But, due to certain constrains, I could not do that way.

I hope somebody could help me.

Thank you in advance.

Regards,
../Mizan Received on Wed Feb 06 2002 - 21:28:42 CST