Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You are missing 'SQL' at the beginning of the command. Try like:
SQL EXEC .....
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'));
Have you already created the DB(ODBC/OLEDB) connection?
Dear Tresesco,
I have already created ODBC connection..
ODBC CONNECT32 TO [TEST;DBQ=TEST] (XUserId is FKbdfUZMTLYAHYNW, XPassword is EFKIfUZMTDdKWZROCG);
Oracle database? Try Call instead of Exec, like:
SQL Call IFSAPP.COO ......
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'))
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.