0 Replies Latest reply: Dec 14, 2009 2:42 PM by Luca Mirtani RSS

    Call Oracle Procedure from the Publisher

    Luca Mirtani

      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