Loading data from Oracle Stored Procedure with I/p, o/p parameters in Qlik Sense

[shampy19]

Hello All,

I have the oracle stored procedure where it has input, output parameter and result set as a ref cursor. Can anyone guide me on how to load the data in qliksense as I have already created the ODBC connection using oracle driver.

Below is the definition of stored procedure.

PROCEDURE Get_CashRec(

    p_MainBook        IN  VARCHAR2,

    p_CobDate         IN  VARCHAR2,

    p_ResultSet       OUT pk_FOBORec.ResultSetCursorTyp,

    p_RetCode         OUT number,

    p_RetString       OUT VARCHAR2,

    p_restrictTCN_ind IN VARCHAR2 DEFAULT NULL

  );

Qlik Sense Business,#data

[SankarReddyK]

Hi @shampy19 , Please refer the below community thread for sample example.

https://community.qlik.com/t5/QlikView-App-Dev/sql-stored-procedure-input-parameter/td-p/230075

Best Regards,

Sankar.

[shampy19]

@SankarReddyK 

Thanks for the response but in Qlik Sense Input function is not working also I have the input and output parameters to pass along with the ref cursor. So this will not work.