QlikView reading Oracle stored procedure data

Tue, 07 Jun 2016 16:51:32 GMT

Hi,

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

Stored Procedure:

create or replace PROCEDURE MYPROC(p_comment out varchar2)

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

topic QlikView reading Oracle stored procedure data in QlikView

QlikView reading Oracle stored procedure data