5 Replies Latest reply: Oct 4, 2011 2:08 PM by hrdzpqkv RSS

    Oracle stored procedure with Ref Cursor as out put

    Muralidhar Koti

      Hi,

       

      I have the following stored procedure in Oracle. How can I execute this in QlikView to load the data.

       

      CREATE OR REPLACE PROCEDURE Test(reportno IN NUMBER, p_cur OUT sys_refcursor)

      IS
      BEGIN
      IF reportno = 1 THEN
      BEGIN 
        OPEN p_cur FOR
        Select statement comes here;
      END;
      ELSE IF reportno = 2 THEN
      BEGIN
        OPEN p_cur FOR
        Select statement comes here;
      END;
      END IF;
      END IF;
      END Test;

       

      Thanks in advance for your help.

       

      Regards,

      Murali