Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

10 Replies
Not applicable
Author

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
Author

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
Author

Thanks! It's working now

Not applicable
Author

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.

blaise
Partner - Specialist
Partner - Specialist

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
Author

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

Thanks in advance

Not applicable
Author

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
Author

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
Author

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