topic Re: QlikView Stored Procedure Syntax in QlikView

QlikView Stored Procedure Syntax

Tue, 16 Sep 2014 08:29:09 GMT

Hi,

I am looking to use the following stored procedure in QlikView. I can run the following syntax successfully in SQL developer but cannot find the correct QlikView syntax in order to replicate this stored procedure.

declare

out1 NUMBER;

out2 NUMBER;

out3 DATE;

begin

get_function('01','11111','Test',sysdate-24, out1, out2, out3);

dbms_output.put_line('OUTPUT: ' || out1 || ' ' || out2 || ' ' || out3);

end;

Can anyone help advise the correct QlikView syntax?

Kind Regards,

Nikki

Re: QlikView Stored Procedure Syntax

jagan — Tue, 16 Sep 2014 08:32:05 GMT

Hi,

Check this link

Stored Procedure Parameters SQL

Regards,

Jagan.

Re: QlikView Stored Procedure Syntax

Tue, 16 Sep 2014 08:43:15 GMT

Hi Jagan,

Thank you for the link however this article is referring to passing in parameters to the Stored procedure, I am trying to generate the output parameters.

Any ideas?

Kind Regards,

Nikki

Re: QlikView Stored Procedure Syntax

agomes1971 — Tue, 16 Sep 2014 08:48:51 GMT

Hi,

what do you mean by generating output parameters ?

Thanks

André Gomes

Re: QlikView Stored Procedure Syntax

jagan — Tue, 16 Sep 2014 08:52:57 GMT

Hi,

It is not possible in Qlikview, instead if you are able to change the stored procedure like below then it is possible

dbms_output.put_line('OUTPUT: ' || out1 || ' ' || out2 || ' ' || out3)

to Select out1 , out2, out3 from dual for oracle

Select out1 , out2, out3;

By using Peek() we can fetch the values to variables.

Hope this helps you.

Regards,

Jagan.

Re: QlikView Stored Procedure Syntax

Anonymous — Fri, 13 Mar 2015 08:11:56 GMT

Hi,
@jagan; that is nice suggestion.
@Nikki; You can create simple statement in Stored Procedure and extract value from the function and then you can extract that data by calling stored procedure form QlikView.