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

[#1]

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.

[erichshiino]

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

[#3]

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

[erichshiino]

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

[#5]

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