topic Re: How to Execute Stored Procedure in QlikView

How to Execute Stored Procedure

Wed, 06 Aug 2014 06:03:08 GMT

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

Re: How to Execute Stored Procedure

avinashelite — Wed, 06 Aug 2014 06:14:45 GMT

Hi,

Check this links:

Executing a stored procedure

How to call store procedure sql in QlikView

Re: How to Execute Stored Procedure

tresB — Wed, 06 Aug 2014 06:21:25 GMT

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

SQL EXEC .....

Re: How to Execute Stored Procedure

Wed, 06 Aug 2014 06:41:59 GMT

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

Re: How to Execute Stored Procedure

tresB — Wed, 06 Aug 2014 06:49:31 GMT

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

Re: How to Execute Stored Procedure

Wed, 06 Aug 2014 06:51:28 GMT

Dear Tresesco,

I have already created ODBC connection..

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

Re: How to Execute Stored Procedure

tresB — Wed, 06 Aug 2014 06:57:08 GMT

Oracle database? Try Call instead of Exec, like:

SQL Call IFSAPP.COO ......

Re: How to Execute Stored Procedure

Wed, 06 Aug 2014 07:11:47 GMT

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'))

Re: How to Execute Stored Procedure

amilafdo — Wed, 06 Aug 2014 07:16:54 GMT

Hi,

please refer the below link

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

Thanks

Amila

Re: How to Execute Stored Procedure

tresB — Wed, 06 Aug 2014 07:17:15 GMT

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.

Re: How to Execute Stored Procedure

Wed, 06 Aug 2014 07:20:57 GMT

Dear Tresesco,

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

Re: How to Execute Stored Procedure

tresB — Wed, 06 Aug 2014 07:32:35 GMT

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