Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following stored procedure in Oracle. How can I execute this in QlikView to load the data.
CREATE OR REPLACE PROCEDURE Test(reportno IN NUMBER, p_cur OUT sys_refcursor)
IS
BEGIN
IF reportno = 1 THEN
BEGIN
OPEN p_cur FOR
Select statement comes here;
END;
ELSE IF reportno = 2 THEN
BEGIN
OPEN p_cur FOR
Select statement comes here;
END;
END IF;
END IF;
END Test;
Thanks in advance for your help.
Regards,
Murali
Murali,
Did you find out the solution to this?
Thanks in advance.
No. I didn't get any solution for this.
Murali try the below:
ODBC CONNECT TO [Database]
Load *;SQL
Execute [Schema].[Procedure] (<reportno>);
exit script;
Regards,
Kiran.
load*;
select
a,
b,
c,
d,
e,
T.test(arg1,arg2) as StoreprocedureCalling
from T.tablename
fetch above select statement using Connection to database and
add a field as
T.test(arg1,arg2) as StoreprocedureCalling
T is nothing but Schemaname
hope this help
I tested both codes and didn't work.
This is the call on Toad:
DECLARE
V_output SYS_REFCURSOR;
BEGIN
Schema.StoreProcedureName(numparam1, charparam2L, :V_output );
END;
Any idea how to call it on QlikView?