| ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-01722: 수치가 부적합합니다 ### The error may exist in file [/uniforce/sources/new_uniAngelRenew/WebContent/WEB-INF/classes/egovframework/sqlmap/lcms/nrs/EgovNrsMdct_SQL_Oracle.xml] ### The error may involve MedicationDiaryDAO.selectCareMediAllList-Inline ### The error occurred while setting parameters ### SQL: /*MedicationDiaryDAO.selectCareMediAllList*/ SELECT /*+ INDEX(A SSCARE_14M_PK)*/ A.SEQ_NO, A.SEQ_IDX, C.ROOM_NM, C.ROOM_NO, C.ELDER_NM, A.MED_NM, A.MED_MAX, (SELECT SUM(MED_USE) FROM SSCARE_14M_DAILY WHERE REGEXP_LIKE(A.MED_USE, '^(-?[0-9]+(\.[0-9]+)?)$') AND F_CODE = ? AND SEQ_IDX = A.SEQ_IDX AND SEQ_NO = A.SEQ_NO AND TO_DATE(WORK_DT, 'YYYY-MM-DD') BETWEEN TO_DATE(A.START_DT, 'YYYY-MM-DD') AND TO_DATE(?, 'YYYY-MM-DD')) AS MED_TOTAL_USE, NVL(( SELECT MED_USE FROM SSCARE_14M_DAILY WHERE F_CODE = ? AND SEQ_NO = A.SEQ_NO AND SEQ_IDX = A.SEQ_IDX AND WORK_DT = ? ),'0') AS MED_USE, DECODE(A.FLAG_MOR,'Y','Y','-') AS FLAG_MOR, DECODE(A.FLAG_AFT,'Y','Y','-') AS FLAG_AFT, DECODE(A.FLAG_EVE,'Y','Y','-') AS FLAG_EVE, DECODE(A.FLAG_SLE,'Y','Y','-') AS FLAG_SLE, A.START_DT, A.END_DT, A.AMT, B.DAY, B.NURSE, B.A2_NURSE, B.A3_NURSE, B.A4_NURSE, B.D_H, B.D_M, B.A2_D_H, B.A2_D_M, B.A3_D_H, B.A3_D_M, B.A4_D_H, B.A4_D_M, B.B_NURSE, B.B2_NURSE, B.B3_NURSE, B.B_D_H, B.B_D_M, B.B2_D_H, B.B2_D_M, B.B3_D_H, B.B3_D_M, B.RMRK, B.REG_DT, SS_ATTEN_STAT(A.F_CODE, A.SEQ_NO, ?) AS ATTEN_STAT, TO_DATE(A.END_DT, 'YYYY-MM-DD') - TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD') AS DAY_DIFF FROM SSCARE_14M A, SSCARE_01 C ,( SELECT F_CODE, SEQ_NO, REG_DT, RMRK, D16 AS DAY, NURSE16 AS NURSE, A2_NURSE16 AS A2_NURSE, A3_NURSE16 AS A3_NURSE, A4_NURSE16 AS A4_NURSE, D16_H AS D_H, D16_M AS D_M, A2_D16_H AS A2_D_H, A2_D16_M AS A2_D_M, A3_D16_H AS A3_D_H, A3_D16_M AS A3_D_M, A4_D16_H AS A4_D_H, A4_D16_M AS A4_D_M, B_NURSE16 AS B_NURSE, B2_NURSE16 AS B2_NURSE, B3_NURSE16 AS B3_NURSE, B_D16_H AS B_D_H, B_D16_M AS B_D_M, B2_D16_H AS B2_D_H, B2_D16_M AS B2_D_M, B3_D16_H AS B3_D_H, B3_D16_M AS B3_D_M FROM SSCARE_14D WHERE F_CODE = ? AND SUBSTR (REG_DT, 0, 7) = SUBSTR (?, 0, 7) ) B WHERE A.F_CODE = B.F_CODE(+) AND A.SEQ_NO = B.SEQ_NO(+) AND A.F_CODE = C.F_CODE AND A.SEQ_NO = C.SEQ_NO AND A.F_CODE = ? and C.ROOM_NM = ? AND ? BETWEEN A.START_DT AND A.END_DT AND C.OUT_DT IS NULL AND C.DTH_DT IS NULL ORDER BY C.ELDER_NM , A.MED_NM ### Cause: java.sql.SQLSyntaxErrorException: ORA-01722: 수치가 부적합합니다 ; SQL []; ORA-01722: 수치가 부적합합니다 ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: 수치가 부적합합니다 |
