Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

  Smiley Tongue_comment VARCHAR2(30)

call SCUSER.MYPROC(Smiley Sadp_comment)) output

select Smiley Tongue_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

Community Browser