topic Executing Oracle Stored Procedure from Qlikview not working in QlikView

Executing Oracle Stored Procedure from Qlikview not working

Wed, 06 Oct 2010 11:42:29 GMT

i need to call a stored procedure on Oracle unix server with parameters, which fills a table that i later want to load to Qlikview.

So far, i have tried all the ideas i found but with no luck. I'll appreciate your ideas/examples of similar working scripts

Executing Oracle Stored Procedure from Qlikview not working

Wed, 06 Oct 2010 13:16:01 GMT

I use the command

SQL CALL PRC_TEST('$(var1)', '$(var2)');

Var1 and Var2 are the variables that i declare on the script, but you can put values too

SQL CALL PRC_TEST('1', '2', 'USER_NAME');

Executing Oracle Stored Procedure from Qlikview not working

Wed, 06 Oct 2010 14:04:15 GMT

Make sure you got the Script Setting "Open Databases in Read and Write Mode" checked.

QlikView will open databases in Read mode by default. Stored procedures will probably require Write access.

Executing Oracle Stored Procedure from Qlikview not working

Wed, 13 Oct 2010 09:27:21 GMT

Thanks! It's working now

Executing Oracle Stored Procedure from Qlikview not working

Wed, 13 Oct 2010 09:41:00 GMT

Thanks so much! It's working great.

I need to take this a step further. Perhaps you can help me here too?

From an existing Qlikview sheet, i need to be able to click on an item and send its value as the parameter to the stored procedure.

i tried building a second qvw with only the call to the SP and a table to show results.

Then i tried adding a button to the first sheet and creating an action to Open new QV document.

The Action is defined is: Select Possible ITEM

Set varialble parameter=ITEM

Open QlikView document newdoc.qvw

Transfer State checked

Apply State on top of current checked

The new QVW opens but the parameter is not passing.

Executing Oracle Stored Procedure from Qlikview not working

blaise — Wed, 13 Oct 2010 10:10:07 GMT

In the "good old days" with 8.5 i would create a vbscript, in 9 their might be a better solution, but I doubt it.

Executing Oracle Stored Procedure from Qlikview not working

Thu, 08 Dec 2011 06:24:35 GMT

I have tried this but its not working....i got runtime error...could u pl help out...

Thanks in advance

Re: Executing Oracle Stored Procedure from Qlikview not working

Thu, 08 Dec 2011 06:26:24 GMT

I have tried this but its not working....i got runtime error...could u pl help out...

I have attached the error file for ref.

Thanks in advance

Re: Executing Oracle Stored Procedure from Qlikview not working

Thu, 08 Dec 2011 07:01:30 GMT

my procedure got executed and data also got inserted into table..

but am facing error which I have attached in my previouse msg.

Re: Executing Oracle Stored Procedure from Qlikview not working

Fri, 05 Jul 2013 11:52:18 GMT

Hello keti.avital

Right now i am trying to do the same like you did (Create VisualBasic script in qlikview that is going to call a Oracle stored procedure) but im having problems with the connection - Could you please share the solution you found back then.

Thanks

Re: Executing Oracle Stored Procedure from Qlikview not working

cchristenson2 — Thu, 06 Jun 2019 19:58:39 GMT

Hi, know that this is closed, but wondering if someone could help me out, trying to execute the following code and wondering why it might not be working:

SQL Execute/Exec/Call EPIC_UTIL.ESP_CR_ALTERED_ROWS 'HSP_ACCOUNT','CLARITY',trunc(sysdate-1),sysdate,true;

$(vTableName):
SQL
SELECT src.*,
cdc.CR_UPD_DATE
from HSP_ACCOUNT src
inner join epic_util.cdc_HSP_ACCOUNT cdc on src.HSP_ACCOUNT_ID = cdc.HSP_ACCOUNT_ID
where rownum < 100;

I've tried the commands in italics above. It works flawlessly if I run it in SQL Developer with Exec in there. Any ideas?