Oracle Stored Procedure

[noman212]

i have a stored procedure in oracle with 5 param 1 is input and remaining 4 are output how i can execute in qlikview ?

[tresB]

Stored Procedure Parameters SQL

[noman212]

what can i do when i have 4 param?

[tresB]

You can pass those parameters while calling like:

Sql exec Procedurename Param1,Param2, Param3, Param4;

[jagan · Accepted solution]

Hi,

Try like this

sql exec  ('[SERVER\XXX].[DBASE].[dbo].[sp_name] $(parameter1),  $(parameter2),$(parameter3),$(parameter4)' ) ;

Regards,

Jagan.