Discussion Board for collaboration on QlikView Publisher.
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 ?
maybe the SQL keyword is missing? I found those discussion:
Executing Oracle Stored Procedure from Qlikview not working
SQL Stored Procedure into QlikView
When i call the procedure with SQL before, i have the error message:
SQL instruction not valide.
There is no solution for me in the 2 links you give me...
This is how i've done.
OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=sagent;Data Source=DSD] (XPassword is MIEaJSBHHLZcGaNOXD); sql call sagent.proc_test_qv();
Are you sur it was for an Oracle stored procedure or for SQL server ?
I tried this for Oracle and it doesn't work...
I have the message: it is not a valide sql instruction.