Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView Stored Procedure Syntax

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

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this link

Stored Procedure Parameters SQL

Regards,

Jagan.

Not applicable
Author

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 

agomes1971
Specialist II
Specialist II

Hi,

what do you mean by generating output parameters ?

Thanks

André Gomes

jagan
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable
Author

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.