How to Execute Stored Procedure

[#1]

Dear All,

I have written one Store procedure in oracle which takes four parameters from user. when i wants to run the below command from Qlikview it shows one error.

EXEC  IFSAPP.COO_Stock('G044','13','03',to_date('08/01/2014 12:00:00 AM','MM/DD/YYYY hh:mi:ss AM'), to_date('08/03/2014 12:00:00 AM','MM/DD/YYYY hh:mi:ss AM'))

Regards,

Masba

[avinashelite]

Hi,

Check this links:

Executing a stored procedure

How to call store procedure sql in QlikView

[tresesco]

You are missing 'SQL' at the beginning of the command. Try like:

SQL EXEC .....

[#4]

Dear Tresesco,

As per your suggestion i have updated my command but still now same problem.Help me

SQL  Exec IFSAPP.COO_Stock('G044','13','03',to_date('08/01/2014 12:00:00 AM','MM/DD/YYYY hh:mi:ss AM'), to_date('08/03/2014 12:00:00 AM','MM/DD/YYYY hh:mi:ss AM'));

[tresesco]

Have you already created the DB(ODBC/OLEDB) connection?

[#6]

Dear Tresesco,

I have already created ODBC connection..

ODBC CONNECT32 TO [TEST;DBQ=TEST] (XUserId is FKbdfUZMTLYAHYNW, XPassword is EFKIfUZMTDdKWZROCG);

[tresesco]

Oracle database? Try Call instead of Exec, like:

SQL  Call IFSAPP.COO ......

[#8]

Yes Oracle Database.

SQL  call IFSAPP.COO_Stock('G044','13','03',to_date('08/01/2014 12:00:00 AM','MM/DD/YYYY hh:mi:ss AM'), to_date('08/03/2014 12:00:00 AM','MM/DD/YYYY hh:mi:ss AM'))

[amilafdo]

Hi,

please refer the below link

http://community.qlik.com/message/571073#571073

Thanks

Amila

[tresesco]

It seems(error message states clearly) that your stored procedure is trying to update/delete/insert into the table which is not possible in a read only connection.