0 Replies Latest reply: Jun 7, 2016 12:55 PM by Laxmaiah Chowdary RSS

    QlikView reading Oracle stored procedure data

    Laxmaiah Chowdary

      Hi,

      I have been asked to retrieve Oracle stored procedure data into QlikView.

       

      Stored Procedure:

      create or replace PROCEDURE MYPROC(p_comment out varchar2)

      AS

      BEGIN

      p_comment := 'success';

      END;

       

      Executing Stored Procedure from Oracle:

      set serveroutput on;

      DECLARE

        p_comment VARCHAR2(10);

      BEGIN

        MYPROC(p_comment);

        DBMS_OUTPUT.PUT_LINE(p_comment);

      END;


      QlikView Script:

      OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;mode is write;Persist Security Info=True;User ID=scuser;Data Source=***********************;Extended Properties=""] (XPassword is cPWNCSJOHLbGCYEHRRMIJ);

       

      SQL

      DECLARE

        :p_comment VARCHAR2(30)

      call SCUSER.MYPROC(:(p_comment)) output

      select :p_comment as p_comment from dual;

       

      The above script is not fetching p_comment data from SP.

       

      Could you please take a look at it and help me out.

       

      Thank you,

      Laxmaiah Chowdary