eFormServer.iBATIS.log_2016-10-13 6.7 KB

123456789101112131415161718192021222324252627282930313233343536
  1. [Logging Date Time: 2016-10-13 16:34:12,059] =====================================================================================
  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-13 16:34:12,059] =====================================================================================
  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-13 16:34:12,184] =====================================================================================
  6. SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1784034], param1=[ordtype,I], param2=[orddd,20160520], param3=[dschdd,], param4=[cretno,1], param5=[filesize,1], param6=[formcd,1300011947], param7=[pageno,1], param8=[ocrtag,], param9=[userid,104796]]
  7. [Logging Date Time: 2016-10-13 16:34:12,184] =====================================================================================
  8. SQL Command - Statement Id: [setFileName] Parameters: [param0=[pid,1784034], param1=[ordtype,I], param2=[orddd,20160520], param3=[dschdd,], param4=[cretno,1], param5=[filesize,1], param6=[formcd,1300011947], param7=[pageno,1], param8=[ocrtag,], param9=[userid,104796]]
  9. [Logging Date Time: 2016-10-13 16:34:12,185] =====================================================================================
  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-13 16:34:12,185] =====================================================================================
  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-13 16:34:12,404] =====================================================================================
  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-13 16:34:12,404] =====================================================================================
  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-13 16:34:12,405] =====================================================================================
  18. SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,1784034], param1=[ordtype,I], param2=[orddd,20160520], param3=[dschdd,], param4=[formcd,1300011947], param5=[ocrtag,], param6=[pageno,1]]
  19. [Logging Date Time: 2016-10-13 16:34:12,405] =====================================================================================
  20. SQL Command - Statement Id: [getFileName] Parameters: [param0=[pid,1784034], param1=[ordtype,I], param2=[orddd,20160520], param3=[dschdd,], param4=[formcd,1300011947], param5=[ocrtag,], param6=[pageno,1]]
  21. [Logging Date Time: 2016-10-13 16:34:12,405] =====================================================================================
  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-13 16:34:12,405] =====================================================================================
  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]]