How do I return a recordset from a stored procedure

Hello,

[Quoted] I am new to Oracle. I am trying to return the result of a simple query [Quoted] through a stored procedure.

What I have inside the stored procedure look like this:

    select * from table_a where field1 = 'value'

When I execute the stored procedure from SQLPlus, I would like the result to [Quoted] [Quoted] look as though I had execute the select statement directory.

[Quoted] Can anyone help?

---
Phil