Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
what do you mean by generating output parameters ?
Thanks
André Gomes
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.
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.