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.
