Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nicolas_ehrmann
New Contributor

Problem to laungh au stored procedure from pulisher.

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.

4 Replies
bbi_mba_76
Valued Contributor

Re: Problem to laungh au stored procedure from pulisher.

Hi,

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

Executing Oracle Stored Procedure from Qlikview not working

SQL Stored Procedure into QlikView

nicolas_ehrmann
New Contributor

Re: Problem to laungh au stored procedure from pulisher.

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
Valued Contributor

Re: Problem to laungh au stored procedure from pulisher.

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

nicolas_ehrmann
New Contributor

Re: Problem to laungh au stored procedure from pulisher.

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

Community Browser