/* Formatted on 12/15/2014 12:50:37 PM (QP5 v5.256.13226.35538) */
CREATE OR REPLACE PROCEDURE rc1(rc OUT SYS_REFCURSOR) AS
BEGIN
  OPEN rc FOR
    SELECT       ROWNUM
    FROM         DUAL
    CONNECT BY   LEVEL < 11;
END;
/

CREATE OR REPLACE PROCEDURE rc2(rc OUT SYS_REFCURSOR) AS
  sql_stmt   VARCHAR2(100) := 'SELECT       ROWNUM
     FROM         DUAL
     CONNECT BY   LEVEL < 11';
BEGIN
  OPEN rc FOR sql_stmt;
END;
/

CREATE OR REPLACE PROCEDURE rc3(rc OUT SYS_REFCURSOR) AS
  CURSOR c1  IS
    SELECT       ROWNUM
    FROM         DUAL
    CONNECT BY   LEVEL < 11;
BEGIN
  NULL;
END;
/