4 Replies Latest reply: Oct 25, 2013 10:07 AM by Nicolas Ehrmann RSS

    Problem to laungh au stored procedure from pulisher.

    Nicolas Ehrmann

      Hello,

      I am working with Qlikview v.11 SR1.

      I am try to call au stored procedure from the publisher throw a datacommand, the procedure is on Oracle.

      the connexion string:

      Provider=OraOLEDB.Oracle;Data Source=MyDB;User ID=xxxx; Password =xxxxx

      and the text to call the procedure:

      CALL PROCEDURE MISEAJOURRTM('DGDR', 'Debut')

       

      The procedure is updating some table in my database.

       

      Where i run the publisher task i have a message than telle me its is not a valide name for a procedure or function.

       

      But i run it in my oracle sql developper an it works.

       

      Does some one have ever tried to lanch an oracle procedure store from publisher ?

       

      Thanks.

      Nicolas.