IBM Informix Dynamic Server Version 11.50.UC5XA.
I have a Informix database. This database contain a stored procedure with name of 'sp_agent_details' that get two DateTime Parameter. This stored procedure results about 27 columns and I want only few columns of it for reporting. I try this syntax: select AGENT_NAME, AGENT_LOGIN_ID from TABLE(sp_agent_detail('2014-02-04 04:00:00', '2014-02-04 23:00:00')) This Result such Error: java.sql.SQLException: Illegal SQL statement in SPL routine. Next I try this syntax: select AGENT_NAME, AGENT_LOGIN_ID from TABLE(MULTISET{sp_agent_call_summary ('2014-02-04 04:00:00', '2014-02-04 23:00:00')}) Result: java.sql.SQLException: Function (informix.sp_agent_call_summary) returns too many values. then I tried this: select AGENT_NAME, AGENT_LOGIN_ID from TABLE(sp_agent_detail('2014-02-04 04:00:00', '2014-02-04 23:00:00')) (AGENT_NAME, AGENT_LOGIN_ID, other columns that are returned by SP) Result: java.sql.SQLException: Illegal SQL statement in SPL routine.
I have a Informix database. This database contain a stored procedure with name of 'sp_agent_details' that get two DateTime Parameter. This stored procedure results about 27 columns and I want only few columns of it for reporting. I try this syntax: select AGENT_NAME, AGENT_LOGIN_ID from TABLE(sp_agent_detail('2014-02-04 04:00:00', '2014-02-04 23:00:00')) This Result such Error: java.sql.SQLException: Illegal SQL statement in SPL routine. Next I try this syntax: select AGENT_NAME, AGENT_LOGIN_ID from TABLE(MULTISET{sp_agent_call_summary ('2014-02-04 04:00:00', '2014-02-04 23:00:00')}) Result: java.sql.SQLException: Function (informix.sp_agent_call_summary) returns too many values. then I tried this: select AGENT_NAME, AGENT_LOGIN_ID from TABLE(sp_agent_detail('2014-02-04 04:00:00', '2014-02-04 23:00:00')) (AGENT_NAME, AGENT_LOGIN_ID, other columns that are returned by SP) Result: java.sql.SQLException: Illegal SQL statement in SPL routine.
Asked by Hojjat Jashnniloofar
(33 rep)
Mar 8, 2014, 07:35 AM
Last activity: Sep 23, 2022, 02:20 PM
Last activity: Sep 23, 2022, 02:20 PM