[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