Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView reading Oracle stored procedure data

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

0 Replies