Oracle Stored Procedures | JDBC

I have oracle 7.3 server.
I am developing a client server app. using Sun's jdk 1.1.6 and jdbc drivers.

I would like to have, Oracle stored procs that return, multiple rows. For example
select emp, empId from employee
where age > 18
I want this to be part of stored proc. The result of this query will be more than
1 row. How to make stored procs return multiple rows ?

If I could, how I process that within java ?

Any help would be greatly appreciated.

Best Regards,
Deva Received on Wed Aug 19 1998 - 00:50:13 CDT