topic How can i pull data from Oracle using Store Procedure in QlikView? in QlikView

How can i pull data from Oracle using Store Procedure in QlikView?

Thu, 12 Apr 2012 01:55:18 GMT

How can I pull data from Oracle using Store Procedure in QlikView? May be someone know this SQL solution to store data from Oracle / SQL Server into QVD from store procedure. Can someone give me the code?

Thanks,

Danny H.

How can i pull data from Oracle using Store Procedure in QlikView?

erichshiino — Thu, 12 Apr 2012 02:15:48 GMT

Hi, Danny

I usually use one of the codes mentioned by Johannes Sunden on this thread

http://community.qlik.com/message/38979#38979

Hope this helps,

Erich

Re: How can i pull data from Oracle using Store Procedure in QlikView?

Thu, 12 Apr 2012 02:43:43 GMT

Why this code is error? May be my syntac is wrong in QlikView Script

PROCEDURE:

SQL CALL FEIS_MASTER_LOV_PKG.FEIS_MASTER_REGM_FETCH(1000);

STORE PROCEDURE into PROCEDURE.qvd;

Thanks

How can i pull data from Oracle using Store Procedure in QlikView?

erichshiino — Thu, 12 Apr 2012 02:53:50 GMT

Hi,

You need to add (mode is write) before the end of the connection string to properly execute it.

You also need to mark the checkbox that says ' Open database in read & write mode' in the bottom of the script windows, in the 'settings' tab

You could also try:

SQL SELECT FEIS_MASTER_LOV_PKG.FEIS_MASTER_REGM_FETCH(1000);

Regards,

Erich

Re: How can i pull data from Oracle using Store Procedure in QlikView?

Thu, 12 Apr 2012 04:57:47 GMT

I have setting connection again. after connection to database success, i open tab advance but the setting mode read & write always disable.

Can you explain me more detail with the code?

Thanks