Problem with stored procedure / stored function

In Ms-SqlServer i use stored procedure to return a recordset.
My procedure is like that :

Create Procedure procedureName(par1 ...) AS
Select *
From TableName

In Delphi i execute this stored procedure and it return a recordset.

Is there a way to do the same in Oracle ?

Thanks in advance