stored procedure can return recordset?

[sallo]

Hi

anyone have idea abt returing recordset from stored procedure as i use to do in sql server stored procedure.
sql server has capacity to return result set which is use in crystal report for drawing reports. as thr any way i do same, returing recordset from oracle 8i stored procdure and then use it in oracle report builder.
thanx in advance