What is a return type for Oracle stored proc which used to create store proc QS

[NetSpace]

What is a return type for Oracle stored proc which used to createÃ,  store proc QS?:

types.ref_cursor or
table variable


CREATE OR REPLACE FUNCTION sp_dosomething(list of params)
RETURN types.ref_cursor
AS
....


Are there any other options?