topic Oracle Stored Procedure in QlikView

Oracle Stored Procedure

noman212 — Fri, 18 Jul 2014 04:52:42 GMT

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 — Fri, 18 Jul 2014 04:56:56 GMT

noman212 — Fri, 18 Jul 2014 05:17:25 GMT

what can i do when i have 4 param?

tresB — Fri, 18 Jul 2014 05:38:06 GMT

You can pass those parameters while calling like:

Sql exec Procedurename Param1,Param2, Param3, Param4;

jagan — Fri, 18 Jul 2014 05:47:37 GMT

Hi,

Try like this

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

Regards,

Jagan.