Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Executing Oracle Stored Procedure from Qlikview not working

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

1 Solution

Accepted Solutions
Not applicable

Executing Oracle Stored Procedure from Qlikview not working

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');

10 Replies
Not applicable

Executing Oracle Stored Procedure from Qlikview not working

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');

Not applicable

Executing Oracle Stored Procedure from Qlikview not working

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.

Not applicable

Executing Oracle Stored Procedure from Qlikview not working

Thanks! It's working now

Not applicable

Executing Oracle Stored Procedure from Qlikview not working

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.

Partner
Partner

Executing Oracle Stored Procedure from Qlikview not working

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.

Not applicable

Executing Oracle Stored Procedure from Qlikview not working

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

Thanks in advance

Not applicable

Re: Executing Oracle Stored Procedure from Qlikview not working

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

Not applicable

Re: Executing Oracle Stored Procedure from Qlikview not working

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

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

Not applicable

Re: Executing Oracle Stored Procedure from Qlikview not working

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