Hello. I want to use an Oracle Procedure in a QlikView application. I added this code to my script:
CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxx;Password=yyy;Data Source=BAAN;Extended Properties=""](mode is write);
CALL DWH.MY_ORACLE_PROCEDURE();
I have also activated the flag "Open databases in Read and write mode" in the security tab.
If I reload the data from the developer the document work correctly but if I reload it from the Publisher it does not work!!!
Thank you, Capetto