Oracle - Returning Result Sets from Stored Procedures

You can use the OPEN cursor statement and refcursor OUT parameter to return a result set from a PL/SQL stored procedure.

Example:

CREATE OR REPLACE PROCEDURE GetOrderInfo(v_data IN NUMBER, v_refcur OUT SYS_REFCURSOR)
AS
BEGIN
  OPEN v_refcur FOR 
    SELECT * FROM dbo.OrderInfo WHERE data = v_data; 
END;

Returning Result Sets - Differences between Oracle and other Databases