this is xml
<resultMap id="result_report_QDHW_05" class="com.sunyard.csr.vo.Report_QDHW_05">
<result property="TIME_KEY" column="TIME_KEY"/>
<result property="AGENT_ID" column="AGENT_ID"/>
<result property="AGENT_NAME" column="AGENT_NAME"/>
<result property="RESULT_01" column="RESULT_01"/>
<result property="RESULT_02" column="RESULT_02"/>
<result property="RESULT_03" column="RESULT_03"/>
<result property="RESULT_04" column="RESULT_04"/>
<result property="RESULT_05" column="RESULT_05"/>
<result property="RESULT_06" column="RESULT_06"/>
<result property="RESULT_07" column="RESULT_07"/>
<result property="RESULT_08" column="RESULT_08"/>
<result property="RESULT_09" column="RESULT_09"/>
<result property="RESULT_10" column="RESULT_10"/>
<result property="RESULT_11" column="RESULT_11"/>
<result property="RESULT_12" column="RESULT_12"/>
<result property="RESULT_13" column="RESULT_13"/>
<result property="RESULT_14" column="RESULT_14"/>
</resultMap>
<parameterMap id="parameter_report_QDHW_05" class="java.util.HashMap" >
<parameter property="BEGIN_DATE" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="END_DATE" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="STAFF_ID" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="STAFF_NAME" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="start" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="limit" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="ret_code" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="ret_message" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="countall" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
<parameter property="cur_ret" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="result_report_QDHW_05"/>
</parameterMap>
<procedure id="report_QDHW_05" resultClass="java.util.HashMap" parameterMap="parameter_report_QDHW_05">
{call QD_RPT_HW05(?,?,?,?,?,?,?,?,?,?) }
</procedure >this is a stored procedure
CREATE OR REPLACE PROCEDURE QD_RPT_HW05
(BEGINDATE IN VARCHAR2,
ENDDATE IN VARCHAR2,
AGENTID IN VARCHAR2,
AGENTNAME IN VARCHAR2,
start1 IN NUMBER,
limit1 IN NUMBER,
AN_O_RET_CODE OUT NUMBER,
AC_O_RET_MSG OUT VARCHAR2,
COUNTALL OUT NUMBER,
CUR_RET OUT PKG_PUB_UTILS.REFCURSOR
)
----*****************************************************************
---- :SP_RPT_ANSWERLV_DAY
----:
----:
----:
----:,
----:
----:
----:
----:2016-06-07
----:
----:
----:
----:
----:Sunyard
----COALESCE(t1.TIME_KEY, """") as TIME_KEY,
----*****************************************************************
as
limit2 NUMBER := 0;
execsql VARCHAR2(4000) :="";
BEGIN
AN_O_RET_CODE := 0;
AC_O_RET_MSG := "";
execute IMMEDIATE "TRUNCATE TABLE TB_RPT_RESULT_ALL";
execsql :="insert into TB_RPT_RESULT_ALL (TIME_KEY,AGENT_ID,AGENT_NAME,RESULT_01,RESULT_02,RESULT_03,RESULT_04,RESULT_05,RESULT_06,RESULT_07,RESULT_08,RESULT_09,RESULT_10,RESULT_11,RESULT_12,RESULT_13,RESULT_14)
(select COALESCE(t1.time_key, """") as TIME_KEY,COALESCE(t4.LOGINCODE, """") as AGENT_ID,COALESCE(t4.name, """") as AGENT_NAME,
sum(n_inbound) as RESULT_01,
to_char(trunc(sysdate)+round(case when sum(n_inbound)=0 then 0 else to_number(sum(t_inbound))/sum(n_inbound) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_02,
to_char(trunc(sysdate)+round(case when sum(n_work)=0 then 0 else to_number(sum(t_work))/sum(n_work) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_03,
floor(sum(T_LOGIN)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_LOGIN)/(60*60*24),""hh24:mi:ss"") as RESULT_04,
floor(sum(T_WAIT)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_WAIT)/(60*60*24),""hh24:mi:ss"") as RESULT_05,
floor(sum(t_inbound)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(t_inbound)/(60*60*24),""hh24:mi:ss"") as RESULT_06,
floor(sum(T_WORK)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_WORK)/(60*60*24),""hh24:mi:ss"") as RESULT_07,
floor(sum(T_NOT_READY_TIME)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_NOT_READY_TIME)/(60*60*24),""hh24:mi:ss"") as RESULT_08,
floor(sum(t_ring_inbound)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(t_ring_inbound)/(60*60*24),""hh24:mi:ss"") as RESULT_09,
sum(N_OUTBOUND) as RESULT_10,
to_char(trunc(sysdate)+round(case when sum(n_outbound)=0 then 0 else to_number(sum(t_outbound))/sum(n_outbound) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_11,
floor(sum(t_outbound)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(t_outbound)/(60*60*24),""hh24:mi:ss"") as RESULT_12,
to_char(trunc(sysdate)+round(case when sum(n_ring_inbound)=0 then 0 else to_number(sum(t_ring_inbound))/sum(n_ring_inbound) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_13,
to_char(trunc(sysdate)+round(case when sum(N_NOT_READY)=0 then 0 else to_number(sum(T_NOT_READY_TIME))/sum(N_NOT_READY) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_14
from GEN_ETL.R_AG_1_DAY@TO_CCGENESYS t1,
GEN_ETL.O_AG_1_DAY@TO_CCGENESYS t2
left join TB_SSO_OPER t4
on t4.WORKID=t2.object_name
where t1.object_id=t2.object_id and (n_inbound!=0 or N_OUTBOUND!=0)
and substr(time_key,1,8) >= """||BEGINDATE||"""
and substr(time_key,1,8) <= """||ENDDATE||"""
and ( """||agentid||""" =t4.LOGINCODE or """||agentid||""" = ""ALL"")and t4.LOGINCODE is not null
and t4.name like ""%"|| AGENTNAME||"%""
group by (t4.LOGINCODE,t4.name,t1.time_key)
union all
select """" as TIME_KEY, """" as AGENT_ID,"""" as AGENT_NAME,
sum(n_inbound) as RESULT_01,
to_char(trunc(sysdate)+round(case when sum(n_inbound)=0 then 0 else to_number(sum(t_inbound))/sum(n_inbound) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_02,
to_char(trunc(sysdate)+round(case when sum(n_work)=0 then 0 else to_number(sum(t_work))/sum(n_work) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_03,
floor(sum(T_LOGIN)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_LOGIN)/(60*60*24),""hh24:mi:ss"") as RESULT_04,
floor(sum(T_WAIT)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_WAIT)/(60*60*24),""hh24:mi:ss"") as RESULT_05,
floor(sum(t_inbound)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(t_inbound)/(60*60*24),""hh24:mi:ss"") as RESULT_06,
floor(sum(T_WORK)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_WORK)/(60*60*24),""hh24:mi:ss"") as RESULT_07,
floor(sum(T_NOT_READY_TIME)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(T_NOT_READY_TIME)/(60*60*24),""hh24:mi:ss"") as RESULT_08,
floor(sum(t_ring_inbound)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(t_ring_inbound)/(60*60*24),""hh24:mi:ss"") as RESULT_09,
sum(N_OUTBOUND) as RESULT_10,
to_char(trunc(sysdate)+round(case when sum(n_outbound)=0 then 0 else to_number(sum(t_outbound))/sum(n_outbound) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_11,
floor(sum(t_outbound)/(60*60*24)) || "" ""||to_char(trunc(sysdate)+sum(t_outbound)/(60*60*24),""hh24:mi:ss"") as RESULT_12,
to_char(trunc(sysdate)+round(case when sum(n_ring_inbound)=0 then 0 else to_number(sum(t_ring_inbound))/sum(n_ring_inbound) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_13,
to_char(trunc(sysdate)+round(case when sum(N_NOT_READY)=0 then 0 else to_number(sum(T_NOT_READY_TIME))/sum(N_NOT_READY) end, 4)/(60*60*24),""hh24:mi:ss"") as RESULT_14
from GEN_ETL.R_AG_1_DAY@TO_CCGENESYS t1,
GEN_ETL.O_AG_1_DAY@TO_CCGENESYS t2
left join TB_SSO_OPER t4
on t4.WORKID=t2.object_name
where t1.object_id=t2.object_id and (n_inbound!=0 or N_OUTBOUND!=0)
)
";
-- execute IMMEDIATE execsql;
select COUNT (*) INTO COUNTALL from (
select COALESCE(t1.time_key, "") as TIME_KEY,COALESCE(t4.LOGINCODE, "") as AGENT_ID,COALESCE(t4.name, "") as AGENT_NAME,
sum(n_inbound) as RESULT_01,
to_char(trunc(sysdate)+round(case when sum(n_inbound)=0 then 0 else to_number(sum(t_inbound))/sum(n_inbound) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_02,
to_char(trunc(sysdate)+round(case when sum(n_work)=0 then 0 else to_number(sum(t_work))/sum(n_work) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_03,
floor(sum(T_LOGIN)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_LOGIN)/(60*60*24),"hh24:mi:ss") as RESULT_04,
floor(sum(T_WAIT)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_WAIT)/(60*60*24),"hh24:mi:ss") as RESULT_05,
floor(sum(t_inbound)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(t_inbound)/(60*60*24),"hh24:mi:ss") as RESULT_06,
floor(sum(T_WORK)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_WORK)/(60*60*24),"hh24:mi:ss") as RESULT_07,
floor(sum(T_NOT_READY_TIME)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_NOT_READY_TIME)/(60*60*24),"hh24:mi:ss") as RESULT_08,
floor(sum(t_ring_inbound)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(t_ring_inbound)/(60*60*24),"hh24:mi:ss") as RESULT_09,
sum(N_OUTBOUND) as RESULT_10,
to_char(trunc(sysdate)+round(case when sum(n_outbound)=0 then 0 else to_number(sum(t_outbound))/sum(n_outbound) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_11,
floor(sum(t_outbound)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(t_outbound)/(60*60*24),"hh24:mi:ss") as RESULT_12,
to_char(trunc(sysdate)+round(case when sum(n_ring_inbound)=0 then 0 else to_number(sum(t_ring_inbound))/sum(n_ring_inbound) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_13,
to_char(trunc(sysdate)+round(case when sum(N_NOT_READY)=0 then 0 else to_number(sum(T_NOT_READY_TIME))/sum(N_NOT_READY) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_14
from GEN_ETL.R_AG_1_DAY@TO_CCGENESYS t1,
GEN_ETL.O_AG_1_DAY@TO_CCGENESYS t2
left join TB_SSO_OPER t4
on t4.WORKID=t2.object_name
where t1.object_id=t2.object_id and (n_inbound!=0 or N_OUTBOUND!=0)
and substr(time_key,1,8) >= ""||BEGINDATE||""
and substr(time_key,1,8) <= ""||ENDDATE||""
and ( ""||agentid||"" =t4.LOGINCODE or ""||agentid||"" = "ALL")and t4.LOGINCODE is not null
and t4.name like "%"|| AGENTNAME||"%"
group by (t4.LOGINCODE,t4.name,t1.time_key)
)
where
(( AGENT_ID ="" and AGENT_NAME ="" and TIME_KEY ="" )
or (AGENT_ID<>"" and AGENT_NAME<>"") )
;
limit2:=limit1;
if limit1<0 then
limit2:=COUNTALL;
end if;
--/* */
OPEN CUR_RET FOR
SELECT * FROM ( SELECT ROWNUM AS ROW_NUM,TT.* FROM (
select COALESCE(t1.time_key, "") as TIME_KEY,COALESCE(t4.LOGINCODE, "") as AGENT_ID,COALESCE(t4.name, "") as AGENT_NAME,
sum(n_inbound) as RESULT_01,
to_char(trunc(sysdate)+round(case when sum(n_inbound)=0 then 0 else to_number(sum(t_inbound))/sum(n_inbound) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_02,
to_char(trunc(sysdate)+round(case when sum(n_work)=0 then 0 else to_number(sum(t_work))/sum(n_work) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_03,
floor(sum(T_LOGIN)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_LOGIN)/(60*60*24),"hh24:mi:ss") as RESULT_04,
floor(sum(T_WAIT)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_WAIT)/(60*60*24),"hh24:mi:ss") as RESULT_05,
floor(sum(t_inbound)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(t_inbound)/(60*60*24),"hh24:mi:ss") as RESULT_06,
floor(sum(T_WORK)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_WORK)/(60*60*24),"hh24:mi:ss") as RESULT_07,
floor(sum(T_NOT_READY_TIME)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(T_NOT_READY_TIME)/(60*60*24),"hh24:mi:ss") as RESULT_08,
floor(sum(t_ring_inbound)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(t_ring_inbound)/(60*60*24),"hh24:mi:ss") as RESULT_09,
sum(N_OUTBOUND) as RESULT_10,
to_char(trunc(sysdate)+round(case when sum(n_outbound)=0 then 0 else to_number(sum(t_outbound))/sum(n_outbound) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_11,
floor(sum(t_outbound)/(60*60*24)) || " "||to_char(trunc(sysdate)+sum(t_outbound)/(60*60*24),"hh24:mi:ss") as RESULT_12,
to_char(trunc(sysdate)+round(case when sum(n_ring_inbound)=0 then 0 else to_number(sum(t_ring_inbound))/sum(n_ring_inbound) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_13,
to_char(trunc(sysdate)+round(case when sum(N_NOT_READY)=0 then 0 else to_number(sum(T_NOT_READY_TIME))/sum(N_NOT_READY) end, 4)/(60*60*24),"hh24:mi:ss") as RESULT_14
from GEN_ETL.R_AG_1_DAY@TO_CCGENESYS t1,
GEN_ETL.O_AG_1_DAY@TO_CCGENESYS t2
left join TB_SSO_OPER t4
on t4.WORKID=t2.object_name
where t1.object_id=t2.object_id and (n_inbound!=0 or N_OUTBOUND!=0)
and substr(time_key,1,8) >= ""||BEGINDATE||""
and substr(time_key,1,8) <= ""||ENDDATE||""
and ( ""||agentid||"" =t4.LOGINCODE or ""||agentid||"" = "ALL")and t4.LOGINCODE is not null
and t4.name like "%"|| AGENTNAME||"%"
group by (t4.LOGINCODE,t4.name,t1.time_key)
) TT WHERE
(( AGENT_ID ="" and AGENT_NAME =""and TIME_KEY ="" )
or (AGENT_ID<>"" and AGENT_NAME<>""))
order by 1, 2) WHERE
ROW_NUM BETWEEN start1 AND limit2
;
EXCEPTION
WHEN OTHERS THEN
AN_O_RET_CODE := -1;
AC_O_RET_MSG := ":" || SQLCODE || CHR(13) || ":" || SQLERRM;
END QD_RPT_HW05;
this is an error message
ActionServlet................................
action=========================[com.sunyard.csr.action.GetReportAction@1d0f0db]
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>{END_DATE=20180822, STAFF_NAME=, limit=10, bbtype=typeday, BEGIN_DATE=20180822, STAFF_ID=qd1999, IS_EXPORT_TYPE=3, session=no, start=0, REPORT_TYPE=report_QDHW_05}
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17062];
--- The error occurred in com/sunyard/csr/dao/xml/UserCalReport.xml.
--- The error occurred while applying a parameter map.
--- Check the UserCalReport.parameter_report_QDHW_05.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Ref ; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/sunyard/csr/dao/xml/UserCalReport.xml.
--- The error occurred while applying a parameter map.
--- Check the UserCalReport.parameter_report_QDHW_05.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Ref
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:206)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at com.sunyard.csr.dao.SqlExecuteDao.queryListSqlInfo(SqlExecuteDao.java:76)
at com.sunyard.csr.action.GetReportAction.GetJSONData(GetReportAction.java:825)
at com.sunyard.csr.action.GetReportAction.execute(GetReportAction.java:58)
at com.sunyard.struts.RequestProcessor.process(RequestProcessor.java:82)
at com.sunyard.struts.ActionServlet.process(ActionServlet.java:84)
at com.sunyard.struts.ActionServlet.doPost(ActionServlet.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/sunyard/csr/dao/xml/UserCalReport.xml.
--- The error occurred while applying a parameter map.
--- Check the UserCalReport.parameter_report_QDHW_05.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Ref
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:296)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
... 33 more
Caused by: java.sql.SQLException: Ref
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.getCursorValue(OracleStatement.java:3851)
at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:6011)
at oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:5802)
at oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStatement.java:698)
at org.apache.commons.dbcp.DelegatingCallableStatement.getObject(DelegatingCallableStatement.java:141)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.retrieveOutputParameters(SqlExecutor.java:396)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:286)
at com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
... 40 more
outString[,:SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17062];
--- The error occurred in com/sunyard/csr/dao/xml/UserCalReport.xml.
--- The error occurred while applying a parameter map.
--- Check the UserCalReport.parameter_report_QDHW_05.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Ref ; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/sunyard/csr/dao/xml/UserCalReport.xml.
--- The error occurred while applying a parameter map.
--- Check the UserCalReport.parameter_report_QDHW_05.
--- Check the output parameters (retrieval of output parameters failed).
--- Cause: java.sql.SQLException: Ref ]