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

[#2]

Dear Tresesco,

Thanks for ur reply.. So what will be the solution.. How can i insert data ? Please help me.

[tresesco]

Qlikview's OBDC is read only. However, you can insert data using macro. search this forum for such codes. Some examples:

Insert / Update data into MSSQL

Re: how to write insert,update,delete function in qlikview