Execute a Stored Procedure in Qlik Sense

[devarasu07]

Hi All,

Please refer to the attachment, The following example is for Executing / Call a Stored Procedure from within Qlik Sense.

Thanks

Deva

[Chanty4u]

Hi Deva,

Olivier Robin

i have a created a table in database and  created SP for that table.

but when i tried to use the same am getting below error.

my SP is running succesfully in  DB.

am using SQL sever 2014

[Anonymous]

Hi Chanty!

Insert the database name first:

"database name".dbo.TestSP

Regards.

[rupalimane1390]

Hello,

Could anybody run Oracle stored procedure successfully in qliksense.

I checked almost all threads related to calling Oracle SP in qliksense but could not find successful or completed thread.

I am using following syntax to run Oracle SP in qliksense:

SQL exec dmtx.sp_uk_fc_nc_test_5;

(dmtx is my DB name and sp_uk_fc_nc_test_5 is oracle stored procedure name).

[MMann]

Hi Rupalimane,  

According to: https://community.qlik.com/t5/Knowledge/Calling-a-stored-procedure-or-function-in-Oracle-from-QlikVi...

Try it:

Use the function CALL to specify the name of the stored procedure.