How to connect pl/sql stored procedure to Qlikview

[#1]

Hi All,

Can some one please let me know how to execute a PL/SQL stored procedure in QLIKVIEW?

I just tried Execute procedure_name!!! Its not working.

Thanks and Regards

Swathi

[stabben23]

Hi Swathi,

There are a lot of simular threads here on the community, SEARCH for it.

[satheshreddy]

Hi Swathi,

Find below ..

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=scuser;Data Source=********************;Extended Properties=""] (XPassword is cPWNCSJOHLbGCYEHRRMIJ);

SQL

DECLARE

  :p_comment VARCHAR2(10);

Tab:

Load *;

sql call SCUSER.PROCEDURE5(:$(p_comment));

Regards

Sathish

[infosurya2]

Hi Swathi,

Please find below syntax:

Table:

Load *;

SQL EXEC Stored Procedure Name;