eFormServer.iBATIS.log_2016-10-14 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. [Logging Date Time: 2016-10-14 15:18:39,871] =====================================================================================
  2. SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;]
  3. [Logging Date Time: 2016-10-14 15:18:39,871] =====================================================================================
  4. SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;]
  5. [Logging Date Time: 2016-10-14 15:18:39,911] =====================================================================================
  6. SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1742884], param1=[ordtype,I], param2=[orddd,20161005], param3=[dschdd,], param4=[cretno,1], param5=[filesize,1], param6=[formcd,1033310287], param7=[pageno,1], param8=[ocrtag,2016100560773], param9=[userid,104796]]
  7. [Logging Date Time: 2016-10-14 15:18:39,911] =====================================================================================
  8. SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1742884], param1=[ordtype,I], param2=[orddd,20161005], param3=[dschdd,], param4=[cretno,1], param5=[filesize,1], param6=[formcd,1033310287], param7=[pageno,1], param8=[ocrtag,2016100560773], param9=[userid,104796]]
  9. [Logging Date Time: 2016-10-14 15:18:39,911] =====================================================================================
  10. SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String]]
  11. [Logging Date Time: 2016-10-14 15:18:39,911] =====================================================================================
  12. SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String]]
  13. [Logging Date Time: 2016-10-14 15:18:39,929] =====================================================================================
  14. SQL Command - Statement Id: [getFileName] PreparedStatement : [SELECT d.alias||'\'||'fnuImage'||'\'||substr(c.cdate,1,6)||'\'||substr(c.cdate,7)||'\'||to_char(c.pageno) AS filename FROM cmr.treatt a, cmr.chartpaget b, cmr.paget c, cmr.patht d WHERE a.patid = :param0 AND a.class = :param1 AND a.indate = :param2 AND a.outdate = :param3 and a.TREATNO = b.TREATNO and b.formcode = :param4 and b.ocrcode = :param5 and b.page = :param6 and b.pageno = c.pageno and d.pathid = c.pathid and d.active = 'Y']
  15. [Logging Date Time: 2016-10-14 15:18:39,929] =====================================================================================
  16. SQL Command - Statement Id: [getFileName] PreparedStatement : [SELECT d.alias||'\'||'fnuImage'||'\'||substr(c.cdate,1,6)||'\'||substr(c.cdate,7)||'\'||to_char(c.pageno) AS filename FROM cmr.treatt a, cmr.chartpaget b, cmr.paget c, cmr.patht d WHERE a.patid = :param0 AND a.class = :param1 AND a.indate = :param2 AND a.outdate = :param3 and a.TREATNO = b.TREATNO and b.formcode = :param4 and b.ocrcode = :param5 and b.page = :param6 and b.pageno = c.pageno and d.pathid = c.pathid and d.active = 'Y']
  17. [Logging Date Time: 2016-10-14 15:18:39,929] =====================================================================================
  18. SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,1742884], param1=[ordtype,I], param2=[orddd,20161005], param3=[dschdd,], param4=[formcd,1033310287], param5=[ocrtag,2016100560773], param6=[pageno,1]]
  19. [Logging Date Time: 2016-10-14 15:18:39,929] =====================================================================================
  20. SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,1742884], param1=[ordtype,I], param2=[orddd,20161005], param3=[dschdd,], param4=[formcd,1033310287], param5=[ocrtag,2016100560773], param6=[pageno,1]]
  21. [Logging Date Time: 2016-10-14 15:18:39,929] =====================================================================================
  22. SQL Command - Statement Id: [getFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]
  23. [Logging Date Time: 2016-10-14 15:18:39,929] =====================================================================================
  24. SQL Command - Statement Id: [getFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String]]
  25. [Logging Date Time: 2016-10-14 15:27:56,366] =====================================================================================
  26. SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;]
  27. [Logging Date Time: 2016-10-14 15:27:56,366] =====================================================================================
  28. SQL Command - Statement Id: [setFileName] PreparedStatement : [declare I_PID VARCHAR2(10) := :param0 ; I_IOFLAG VARCHAR2(1) := :param1 ; I_ORDDD VARCHAR2(8) := :param2 ; I_DSCHDD VARCHAR2(8) := :param3 ; I_CRETNO NUMBER(10) := :param4 ; I_FILESIZE NUMBER(18) := :param5 ; I_FORMCD VARCHAR2(10) := :param6 ; I_PAGE NUMBER(18) := :param7 ; I_OCRCODE VARCHAR2(13) := :param8 ; I_USERID VARCHAR2(10) := :param9 ; begin EMR.LCTECH_PROCESS(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FILESIZE, I_FORMCD, I_PAGE, I_OCRCODE, I_USERID); end;]
  29. [Logging Date Time: 2016-10-14 15:27:56,366] =====================================================================================
  30. SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1742884], param1=[ordtype,I], param2=[orddd,20161006], param3=[dschdd,], param4=[cretno,1], param5=[filesize,1], param6=[formcd,1033310287], param7=[pageno,1], param8=[ocrtag,2016100560773], param9=[userid,104796]]
  31. [Logging Date Time: 2016-10-14 15:27:56,366] =====================================================================================
  32. SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1742884], param1=[ordtype,I], param2=[orddd,20161006], param3=[dschdd,], param4=[cretno,1], param5=[filesize,1], param6=[formcd,1033310287], param7=[pageno,1], param8=[ocrtag,2016100560773], param9=[userid,104796]]
  33. [Logging Date Time: 2016-10-14 15:27:56,367] =====================================================================================
  34. SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String]]
  35. [Logging Date Time: 2016-10-14 15:27:56,367] =====================================================================================
  36. SQL Command - Statement Id: [setFileName] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String], param3=[AnsiString, System.String], param4=[AnsiString, System.String], param5=[AnsiString, System.String], param6=[AnsiString, System.String], param7=[AnsiString, System.String], param8=[AnsiString, System.String], param9=[AnsiString, System.String]]
  37. [Logging Date Time: 2016-10-14 15:27:56,828] =====================================================================================
  38. SQL Command - CLIP.eForm error: ORA-01400: NULL을 ("CMR"."CHARTPAGET"."TREATNO") 안에 삽입할 수 없습니다
  39. ORA-06512: "EMR.LCTECH_PROCESS", 141행
  40. ORA-06512: 1행