Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
maybe the SQL keyword is missing? I found those discussion:
Hello,
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...
Nicolas.
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();
Hi,
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.
Nicolas