Problem to laungh au stored procedure from pulisher.

[Anonymous]

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.

[bbi_mba_76]

Hi,

maybe the SQL keyword is missing? I found those discussion:

Executing Oracle Stored Procedure from Qlikview not working

SQL Stored Procedure into QlikView

[Anonymous]

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.

[prabhu0505]

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();

[Anonymous]

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