please help! oracle stored procedure and jdbc

I am getting desperate in trying to implement something that I have not been able to figure out (I have only used sybase till now) and have not gotten much help from a couple Oracle DBA's.

Is it possible to create an oracle stored procedure that will simply allow me to query for multiple rows? I.e. can I execute a stored procedure that might have a few parameters but basically does a 'select c1, c2, c3 from x'? I'm looking for the oracle equivalent of this sybase procedure:

create proc selectX as
{

    select c1, c2, c3 from x;
}

I understand that I will probably need to use cursors somehow, but I'm new to oracle and haven't found a single example anywhere that can do this. Is this possible?

The second thing is that I want to call these procs from a java app using JDBC. Any help would be greatly, greatly appreciated.

Thanks,
Gary Mui
gmui_at_prescientmarkets.com Received on Tue Nov 02 1999 - 08:14:48 CST