oracle (pants!!!)

IS THERE ANY WAY TO RETURN A RECORD SET FROM A STORED PROC
WITH OUT CREATING A PL/SQL PACKAGE!!!!

I WISH TO CREATE THE SP(STORED PROCEDURE) IN THE DATA VIEW WINDOW OF THE DATA ENVIROMENT!

I BELIVE THE CODE WOULD LOOK SOMTHING LIKE!!!

CREATE OR REPLACE PROCEDURE PROCEDURE1
(
PARAMETER1 IN NUMBER,
CURNAME IN OUT CURSOR

)

AS
BEGIN
OPEN CURNAME FOR

SELECT * FROM TABLE

END;

HOWEVER THIS DONT WORK AND I DONT THINK THIS CODE IS ANYWHERE CLOSE TO WHAT IT NEEDS TO BE FOR IT TO WORK!:(

I BELIVE IT IS POSSIBLE BUT I CARNT FIND ANY EGGAMPLES OF SUCH SP`S
OR ANY BOOKS THAT SHOW YOU HOW TO DO IT

CAN ANY BODY HELP ME!!!!

I WOULD LIKE IT TO WORK THE SAME AS IT DOSE WITH SQL 7
BUT I NEED THE CODE FOR THIS AS ORACLE AND SQL 7 HANDLE SP`S COMPETELY DIFFERNT