No result set from stored proc??

[Francois Massey]

Hi everyone,
In the process of converting our MsSql system to Oracle, we were hit in the face by the realization that a PL/SQL stored proc cannot return a result set, i.e., one cannot do a 'select * from Table' inside the stored proc (the sp does not even compile!). Only 'select columnName into varName from table' seems to be allowed. Are we totally offtrack here? Is there really _no_ way of doing that? Thanks for any insight you may have.