dbs289
/
ConsentDemoServer


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
							
[Logging Date Time: 2016-11-07 13:12:47,094] =====================================================================================
SQL Command - Statement Id: [delEformData] 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_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]

[Logging Date Time: 2016-11-07 13:12:47,094] =====================================================================================
SQL Command - Statement Id: [delEformData] 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_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]

[Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]

[Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]

[Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
SQL Command - Statement Id: [delEformData] 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], param10=[AnsiString, System.String]]

[Logging Date Time: 2016-11-07 13:12:47,130] =====================================================================================
SQL Command - Statement Id: [delEformData] 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], param10=[AnsiString, System.String]]

[Logging Date Time: 2016-11-07 13:12:47,209] =====================================================================================
SQL Command - CLIP.eForm delEformData error: ORA-06550: 줄 1, 열1125:PLS-00904: EMR.EFORM_DELETE 오브젝트를 액세스하기 위한 권한이 부족합니다
ORA-06550: 줄 1, 열1121:PL/SQL: Statement ignored


[Logging Date Time: 2016-11-07 13:14:04,453] =====================================================================================
SQL Command - Unable to open connection to "Oracle, Microsoft provider V2.0.0.0".
IBatisNet.DataMapper.Exceptions.DataMapperException: Unable to open connection to "Oracle, Microsoft provider V2.0.0.0". ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

   위치: System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc)
   위치: System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   위치: System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   위치: System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   위치: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   위치: System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   위치: System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   위치: System.Data.OracleClient.OracleConnection.Open()
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   --- 내부 예외 스택 추적의 끝 ---
   위치: IBatisNet.DataMapper.SqlMapSession.OpenConnection(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapSession.BeginTransaction(String connectionString)
   위치: IBatisNet.DataMapper.SqlMapper.BeginTransaction()
   위치: CLIP.eForm.Server.Data.IBatisHelper.GetConnect(String sProvidersPath)

[Logging Date Time: 2016-11-07 13:15:03,042] =====================================================================================
SQL Command - Statement Id: [delEformData] 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_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]

[Logging Date Time: 2016-11-07 13:15:03,042] =====================================================================================
SQL Command - Statement Id: [delEformData] 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_FORMCD           VARCHAR2(10) :=  :param5 ;        /* FORMCD */              I_OCRCODE          VARCHAR2(13) :=  :param6 ;        /* OCRCODE */              I_USERID           VARCHAR2(10) :=  :param7 ;        /* 사용자 ID 실제 동의서 구득 행위를 하는 사람 */              I_USERNM           VARCHAR2(10) :=  :param8 ;      /* 사용자 이름 */              I_CONSENT_MST_RID  NUMBER(18)   :=  :param9 ; /* 동의서 작성 마스터 ID */              I_HOS_TYPE         VARCHAR2(10) :=  :param10 ;       /* 병원구분(대구파티마 - '111') */          begin            EMR.EFORM_DELETE(I_PID, I_IOFLAG, I_ORDDD, I_DSCHDD, I_CRETNO, I_FORMCD, I_OCRCODE, I_USERID, I_USERNM, I_CONSENT_MST_RID, I_HOS_TYPE);          end;]

[Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]

[Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
SQL Command - Statement Id: [delEformData] Parameters: [param0=[pid,2073057], param1=[ordtype,I], param2=[orddd,20161024], param3=[dschdd,99991231], param4=[cretno,1], param5=[formcd,1300011166], param6=[ocrtag,2016102461898], param7=[userid,104591], param8=[username,이정은], param9=[consentmstrid,985], param10=[hostype,111]]

[Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
SQL Command - Statement Id: [delEformData] 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], param10=[AnsiString, System.String]]

[Logging Date Time: 2016-11-07 13:15:03,073] =====================================================================================
SQL Command - Statement Id: [delEformData] 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], param10=[AnsiString, System.String]]

[Logging Date Time: 2016-11-07 20:11:42,202] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]

[Logging Date Time: 2016-11-07 20:11:42,202] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]

[Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]

[Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]

[Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]

[Logging Date Time: 2016-11-07 20:11:42,247] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]

[Logging Date Time: 2016-11-07 20:11:42,270] =====================================================================================
SQL Command - DeleteTempFile : 2016-11-06 오후 8:11:42

[Logging Date Time: 2016-11-07 20:13:09,814] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]

[Logging Date Time: 2016-11-07 20:13:09,814] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] PreparedStatement : [SELECT  CONSENT_MST_RID                , CONSENT_IMAGE_RID                , FORM_RID                , CASE WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image1' THEN '\\192.168.100.32\image_a01' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image2' THEN '\\192.168.100.32\image_a02' || SUBSTR(IMAGE_PATH,7)                       WHEN SUBSTR(IMAGE_PATH,0,6) = 'Image3' THEN '\\192.168.100.32\image_a03' || SUBSTR(IMAGE_PATH,7)                       ELSE IMAGE_PATH                   END IMAGE_PATH                , IMAGE_FILENAME                , COMPLETE_YN                , CREATE_USER_ID                , CREATE_DATETIME            FROM  CONSENT_IMAGE           WHERE  COMPLETE_YN = 'Y'             AND  CONSENT_MST_RID =  :param0            ORDER BY CONSENT_IMAGE_RID]

[Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]

[Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Parameters: [param0=[consent-mst-rid,1157]]

[Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]

[Logging Date Time: 2016-11-07 20:13:09,850] =====================================================================================
SQL Command - Statement Id: [GET_CONSENT_IMAGE] Types: [param0=[Int32, System.Int32]]

[Logging Date Time: 2016-11-07 20:13:09,866] =====================================================================================
SQL Command - DeleteTempFile : 2016-11-06 오후 8:13:09

[Logging Date Time: 2016-11-07 20:13:09,867] =====================================================================================
SQL Command - DeleteTempFile : 2016-11-07 오후 8:10:54