topic Oracle stored procedure with Ref Cursor as out put in QlikView

Oracle stored procedure with Ref Cursor as out put

Thu, 19 May 2011 09:40:31 GMT

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

Oracle stored procedure with Ref Cursor as out put

Anonymous — Fri, 30 Sep 2011 14:50:01 GMT

Murali,

Did you find out the solution to this?

Thanks in advance.

Oracle stored procedure with Ref Cursor as out put

Fri, 30 Sep 2011 14:51:05 GMT

No. I didn't get any solution for this.

Re: Oracle stored procedure with Ref Cursor as out put

Sat, 01 Oct 2011 16:32:16 GMT

Murali try the below:

ODBC CONNECT TO [Database]

Load *;SQL

Execute [Schema].[Procedure] (<reportno>);

exit script;

Regards,

Kiran.

Oracle stored procedure with Ref Cursor as out put

SunilChauhan — Sat, 01 Oct 2011 19:17:43 GMT

load*;

select

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

Re: Oracle stored procedure with Ref Cursor as out put

Anonymous — Tue, 04 Oct 2011 18:08:13 GMT

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?