Returning record sets with a procedure?

[Guest_imported]

What is the best way to return record sets from a calling application, without using an ad hoc sql statement?

I know that I can execute a sql select statement from my calling application and have a record set returned. However, I was trying to put my 'select' statement in a procedure and just call the procedure name with the input parameters. However, I was not able to compile the procedure with just a select statement, the show errors insisted the use of 'select into'.

How do I use a procedure to return a record set? Should I be using a procedure?

 

[sem]

You may return ref cursor.