5 Replies Latest reply: Jan 17, 2014 2:51 PM by John Spencer RSS

    Passing ref cursor as input parameter to procedure




      Is it possible to pass REF cursor as input to another procedure in oracle 11g (11.2)?I am using below statements for same but after storing sql in string variable. at a time of

      procedure call no rows are passed. Below is the code I am using


      v_sql varchar2(4000);


      open lv_cursor for v_sql;


      proc( i_ref_cursour => lv_cursor);


      close lv_cursor;


      When i am checking v_sql before procedure call it has dynamic sql query in it buy while passing it as lv_cursor i.e input to procedure zero rows are passed.