Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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');
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');
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.
Thanks! It's working now
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.
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.
I have tried this but its not working....i got runtime error...could u pl help out...
Thanks in advance
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
my procedure got executed and data also got inserted into table..
but am facing error which I have attached in my previouse msg.
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