UncategorizedAdoException:CommandCallback; uncategorized DataException for SQL [select t.task_id as DOCTASK_ID, t.task_type_id, t.task_name, m.task_dealt_state as TASK_STATE, '' as TASK_LEVEL, m.task_dealt_doc as DOC_ID, t.pid, t.visit_type, t.patient_id, '' as APP_ARGS, m.task_dealt_doc as HANDLE_OPER, m.task_dealt_date as HANDLE_DATE, m.task_dealt_memo as HANDLE_MEMO, '' as TOP_NO, t.create_date, t.oper_code, t.oper_date, t.third_code, P.Name AS PATIENT_NAME, (SELECT D.DISEASE_NAME FROM V_MET_CMN_DIAGNOSE D WHERE D.PID = T.PID AND ROWNUM <= 1) AS PATIENT_DIAGNOSE, P.Birthday AS PATIENT_BIRTHDAY, P.Sex_Code AS SEX_CODE, '' as ENGLISH_NAME, P.Spell_Code, '' as WB_CODE, '' AS DIAG_SPELL, '' AS DIAG_WUBI, t.child_type_id, r.is_focus as major_link_id --1是重点提醒 from met_portal_tasklist t, met_portal_taskdealt m, v_fin_ipr_inmaininfo P,qcm_connotation_rule r where t.task_id = m.task_id and (m.task_dealt_doc = :DOC_CODE OR m.task_dealt_doc = 'ALL') and t.pid = p.Inpatient_No and t.pid = :INPATIENT_NO and t.create_date >= to_date(:BEGIN_DATE,'yyyy-MM-dd HH24:mi:ss') and t.create_date < to_date(:END_DATE,'yyyy-MM-dd HH24:mi:ss') and t.major_link_id = r.rule_code(+) ]; ErrorCode [-2147467259]; ORA-01847: 月份中日的值必须介于 1 和当月最后一日之间 OracleException:ORA-01847: 月份中日的值必须介于 1 和当月最后一日之间 在 Spring.Data.Generic.AdoTemplate.Execute[T](IDbCommandCallback`1 action) 在 Spring.Data.Generic.AdoTemplate.QueryWithResultSetExtractor[T](CommandType commandType, String cmdText, IResultSetExtractor`1 resultSetExtractor, IDbParameters parameters) 在 Spring.Data.Generic.AdoTemplate.QueryWithRowMapper[T](CommandType cmdType, String cmdText, IRowMapper`1 rowMapper, IDbParameters parameters) 在 Neusoft.Dawn.Core.Dal.SqlMstExecutor.QueryWithRowMapper[T](String[] keys, IRowMapper`1 rowMapper, IDictionary`2 parameters) 在 Neusoft.Dawn.Core.Dal.SqlMstExecutor.QueryWithRowMapper[T](String key, IRowMapper`1
扫一扫
928
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
