Discussion Board for collaboration on QlikView Scripting.
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)
ISBEGINIF reportno = 1 THENBEGIN OPEN p_cur FOR Select statement comes here;END;ELSE IF reportno = 2 THENBEGIN OPEN p_cur FOR Select statement comes here;END;END IF;END IF;END Test;
Thanks in advance for your help.
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]
Execute [Schema].[Procedure] (<reportno>);
T.test(arg1,arg2) as StoreprocedureCalling
fetch above select statement using Connection to database and
add a field as
T is nothing but Schemaname
hope this help
I tested both codes and didn't work.
This is the call on Toad:
Schema.StoreProcedureName(numparam1, charparam2L, :V_output );
Any idea how to call it on QlikView?