4 Replies Latest reply: May 30, 2016 9:49 AM by Laxmaiah Chowdary RSS

    Loading Oracle stored procedure from QlikView fails with Wrong number or type of arguments to procedure

    Laxmaiah Chowdary

      Hi Qlik Folks,

      I'm novice to loading stored procedure data to QlikView. I tried out one many a times but it is failing each time with Wrong number or type of arguments to procedure name though it seems there is no error with the number of parameters.

       

      I have already referred below sources but they are not of much help here.

       

      Executing Oracle Stored Procedure from Qlikview... | Qlik Community

      SQL Stored Procedure into QlikView

      How to Call stored procedure in Qlikview

      Re: Executing a stored procedure

       

       

      My table is TEST_QV_TABLEand procedure is PROC_TEST_QV_TABLE.

       

      1).

      DESC TEST_QV_TABLE;

       

      Name  Null Type        

      ----- ---- ------------

      ID         NUMBER(38)  

      NAME       VARCHAR2(10)

      SALES      NUMBER(38)  

      FLAG       VARCHAR2(1) 

       

      2).

      SELECT * FROM TEST_QV_TABLE;

      1John1000T
      2KRISH1200F
      3scott1500T
      4Bob1600F
      5JESSY1800T

       

      3) Stored Procedure:

      -----------------------------

      CREATE OR REPLACE PROCEDURE PROC_TEST_QV_TABLE

      IS

      v_id INTEGER;

      v_name VARCHAR2(10);

      v_sales INTEGER;

      v_flag VARCHAR2(1);

       

      BEGIN

      select ID,NAME,SALES,FLAG into v_id,v_name,v_sales,v_flag from TEST_QV_TABLE

      where TEST_QV_TABLE.ID =v_id;

       

      END;

       

      4) Calling Stored procedure into QlikView

      --------------------------------------------------------

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

       

      SQL CALL PROC_TEST_QV_TABLE(12,'Ravis',3000,'T');

       

      5) Error after reloading:

      --------------------------------

      Capture1.PNG

       

      Actually I want to insert the QlikView called record into table via stored procedure.

       

      Could somebody please help me out.

       

      Thanks in advance,

       

      Regards,

      VLC