ORA-01847: day of month must be between 1 and last day of month

2011-12-26 14:45:00 ERROR AbstractFlushingEventListener:324 [http-8080-1] - Could not synchronize database state with sessionorg.hibernate.exception.DataException: could not update: [com.gpdi.infores.base.domain.SysConfig#656] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2453) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2335) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2635) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027) at org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:420) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:748) at com.gpdi.infores.dao.hibernate.BaseDAOHibernate.saveOrUpdate(BaseDAOHibernate.java:252) at com.gpdi.infores.pipeline.backend.service.impl.SysConfigServiceImpl.saveOrUpdate(SysConfigServiceImpl.java:66) at com.gpdi.infores.pipeline.backend.service.impl.SysConfigServiceImpl$$FastClassByCGLIB$$cba08324.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.gpdi.infores.util.syslog.SysLogEnableInterceptor.invoke(SysLogEnableInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.gpdi.infores.pipeline.backend.service.impl.SysConfigServiceImpl$$EnhancerByCGLIB$$e6de8cce.saveOrUpdate(<generated>) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy153.saveOrUpdate(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205) at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78) at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114) at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:74) at com.gpdi.infores.service.impl.MyHttpInvokerServiceExporter.handleRequest(MyHttpInvokerServiceExporter.java:52) at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619)Caused by: java.sql.SQLException: ORA-01847: day of month must be between 1 and last day of monthORA-06512: at "RMGZ_BZ1.SYS_RES_LOG_SYS_CONFIG", line 21ORA-04088: error during execution of trigger 'RMGZ_BZ1.SYS_RES_LOG_SYS_CONFIG'

 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454) at sun.reflect.GeneratedMethodAccessor181.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at oracle.jdbc.OracleStatement$$EnhancerByProxool$$bf8c9bd2.executeUpdate(<generated>) at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2431) ... 65 more

 

触发器:

CREATE OR REPLACE TRIGGER "SYS_RES_LOG_SYS_CONFIG" AFTER UPDATE OR DELETEON SYS_CONFIG FOR EACH rowDECLARE  vOperID NUMBER(28);  vOperaID Varchar2(20);  vMachine VARCHAR2(256);  vIpAddress VARCHAR2(256);  vRunProgram VARCHAR2(200);  vOSUser VARCHAR2(200);  BEGINIF PK_SYSRESLOG.g_SysLog_Enable = TRUE AND PK_SYSRESLOG.g_Log_Enable = 'TRUE' THEN  SELECT infores_nb.SEQ_RES_OPERLOG.NEXTVAL INTO vOperID FROM dual;  SELECT machine,SYS_CONTEXT('USERENV','IP_ADDRESS'),program,osuser  INTO vMachine,vIpAddress,vRunProgram,vOSUser  FROM sys.v_$session t  WHERE AUDSID=USERENV('SESSIONID');  IF updating() THEN    vOperaID:='修改';    IF updating('CREATESTAFF') AND NVL(:new."CREATESTAFF",'-1')<>NVL(:old."CREATESTAFF",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATESTAFF',:new."KEYID",:old."CREATESTAFF",:new."CREATESTAFF",'M');    END IF;    IF updating('CREATEDATE') AND NVL(:new."CREATEDATE",'-1')<>NVL(:old."CREATEDATE",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATEDATE',:new."KEYID",:old."CREATEDATE",:new."CREATEDATE",'M');    END IF;    IF updating('UPDATESTAFF') AND NVL(:new."UPDATESTAFF",'-1')<>NVL(:old."UPDATESTAFF",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATESTAFF',:new."KEYID",:old."UPDATESTAFF",:new."UPDATESTAFF",'M');    END IF;    IF updating('UPDATEDATE') AND NVL(:new."UPDATEDATE",'-1')<>NVL(:old."UPDATEDATE",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATEDATE',:new."KEYID",:old."UPDATEDATE",:new."UPDATEDATE",'M');    END IF;    IF updating('DESCRIPTION') AND NVL(:new."DESCRIPTION",'-1')<>NVL(:old."DESCRIPTION",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','DESCRIPTION',:new."KEYID",:old."DESCRIPTION",:new."DESCRIPTION",'M');    END IF;    IF updating('FGSID') AND NVL(:new."FGSID",'-1')<>NVL(:old."FGSID",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','FGSID',:new."KEYID",:old."FGSID",:new."FGSID",'M');    END IF;    IF updating('VALUE') AND NVL(:new."VALUE",'-1')<>NVL(:old."VALUE",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','VALUE',:new."KEYID",:old."VALUE",:new."VALUE",'M');    END IF;    IF updating('CONFIGTYPE') AND NVL(:new."CONFIGTYPE",'-1')<>NVL(:old."CONFIGTYPE",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CONFIGTYPE',:new."KEYID",:old."CONFIGTYPE",:new."CONFIGTYPE",'M');    END IF;  END IF;  IF deleting() THEN    vOperaID:='删除';    IF :old."CREATESTAFF" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATESTAFF',:old."KEYID",:old."CREATESTAFF",NULL,'D');    END IF;    IF :old."CREATEDATE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATEDATE',:old."KEYID",:old."CREATEDATE",NULL,'D');    END IF;    IF :old."UPDATESTAFF" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATESTAFF',:old."KEYID",:old."UPDATESTAFF",NULL,'D');    END IF;    IF :old."UPDATEDATE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATEDATE',:old."KEYID",:old."UPDATEDATE",NULL,'D');    END IF;    IF :old."DESCRIPTION" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','DESCRIPTION',:old."KEYID",:old."DESCRIPTION",NULL,'D');    END IF;    IF :old."FGSID" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','FGSID',:old."KEYID",:old."FGSID",NULL,'D');    END IF;    IF :old."VALUE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','VALUE',:old."KEYID",:old."VALUE",NULL,'D');    END IF;    IF :old."CONFIGTYPE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CONFIGTYPE',:old."KEYID",:old."CONFIGTYPE",NULL,'D');    END IF;  END IF;  IF PK_SYSRESLOG.g_UserCode IS NOT NULL THEN    INSERT INTO infores_nb.SYS_RES_OPERLOG(CLIENT_IP,USER_CODE,CLIENT,USER_NAME,ENTITY_TYPE,ENTITY_ID,ENTITY_CODE,OPER_TYPE,OPER_TIME,OPER_ID,RUN_PROGRAM,OS_USER)    VALUES(PK_SYSRESLOG.g_ClientIP,PK_SYSRESLOG.g_UserCode,PK_SYSRESLOG.g_Client,PK_SYSRESLOG.g_UserName,'系统配置表',:new."KEYID",:new."NAME",vOperaID,SysDate,vOperID,vRunProgram,vosuser);  ELSE    INSERT INTO infores_nb.SYS_RES_OPERLOG(CLIENT_IP,USER_CODE,CLIENT,USER_NAME,ENTITY_TYPE,ENTITY_ID,ENTITY_CODE,OPER_TYPE,OPER_TIME,OPER_ID,RUN_PROGRAM,OS_USER)    VALUES(vIpAddress,PK_SYSRESLOG.g_UserCode,vMachine,PK_SYSRESLOG.g_UserName,'系统配置表',:new."KEYID",:new."NAME",vOperaID,SYSDATE,vOperID,vRunProgram,vosuser);  END IF;END IF;END;解决方法:

将创建日期和修改日期改为sysdate，如标有下划线的语句:

CREATE OR REPLACE TRIGGER "SYS_RES_LOG_SYS_CONFIG" AFTER UPDATE OR DELETEON SYS_CONFIG FOR EACH rowDECLARE  vOperID NUMBER(28);  vOperaID Varchar2(20);  vMachine VARCHAR2(256);  vIpAddress VARCHAR2(256);  vRunProgram VARCHAR2(200);  vOSUser VARCHAR2(200);  BEGINIF PK_SYSRESLOG.g_SysLog_Enable = TRUE AND PK_SYSRESLOG.g_Log_Enable = 'TRUE' THEN  SELECT infores_nb.SEQ_RES_OPERLOG.NEXTVAL INTO vOperID FROM dual;  SELECT machine,SYS_CONTEXT('USERENV','IP_ADDRESS'),program,osuser  INTO vMachine,vIpAddress,vRunProgram,vOSUser  FROM sys.v_$session t  WHERE AUDSID=USERENV('SESSIONID');  IF updating() THEN    vOperaID:='修改';    IF updating('CREATESTAFF') AND NVL(:new."CREATESTAFF",'-1')<>NVL(:old."CREATESTAFF",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATESTAFF',:new."KEYID",:old."CREATESTAFF",:new."CREATESTAFF",'M');    END IF;    IF updating('CREATEDATE') AND NVL(:new."CREATEDATE",sysdate)<>NVL(:old."CREATEDATE",sysdate) THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATEDATE',:new."KEYID",:old."CREATEDATE",:new."CREATEDATE",'M');    END IF;    IF updating('UPDATESTAFF') AND NVL(:new."UPDATESTAFF",'-1')<>NVL(:old."UPDATESTAFF",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATESTAFF',:new."KEYID",:old."UPDATESTAFF",:new."UPDATESTAFF",'M');    END IF;    IF updating('UPDATEDATE') AND NVL(:new."UPDATEDATE",sysdate)<>NVL(:old."UPDATEDATE",sysdate) THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATEDATE',:new."KEYID",:old."UPDATEDATE",:new."UPDATEDATE",'M');    END IF;    IF updating('DESCRIPTION') AND NVL(:new."DESCRIPTION",'-1')<>NVL(:old."DESCRIPTION",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','DESCRIPTION',:new."KEYID",:old."DESCRIPTION",:new."DESCRIPTION",'M');    END IF;    IF updating('FGSID') AND NVL(:new."FGSID",'-1')<>NVL(:old."FGSID",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','FGSID',:new."KEYID",:old."FGSID",:new."FGSID",'M');    END IF;    IF updating('VALUE') AND NVL(:new."VALUE",'-1')<>NVL(:old."VALUE",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','VALUE',:new."KEYID",:old."VALUE",:new."VALUE",'M');    END IF;    IF updating('CONFIGTYPE') AND NVL(:new."CONFIGTYPE",'-1')<>NVL(:old."CONFIGTYPE",'-1') THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CONFIGTYPE',:new."KEYID",:old."CONFIGTYPE",:new."CONFIGTYPE",'M');    END IF;  END IF;  IF deleting() THEN    vOperaID:='删除';    IF :old."CREATESTAFF" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATESTAFF',:old."KEYID",:old."CREATESTAFF",NULL,'D');    END IF;    IF :old."CREATEDATE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CREATEDATE',:old."KEYID",:old."CREATEDATE",NULL,'D');    END IF;    IF :old."UPDATESTAFF" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATESTAFF',:old."KEYID",:old."UPDATESTAFF",NULL,'D');    END IF;    IF :old."UPDATEDATE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','UPDATEDATE',:old."KEYID",:old."UPDATEDATE",NULL,'D');    END IF;    IF :old."DESCRIPTION" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','DESCRIPTION',:old."KEYID",:old."DESCRIPTION",NULL,'D');    END IF;    IF :old."FGSID" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','FGSID',:old."KEYID",:old."FGSID",NULL,'D');    END IF;    IF :old."VALUE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','VALUE',:old."KEYID",:old."VALUE",NULL,'D');    END IF;    IF :old."CONFIGTYPE" IS NOT NULL THEN      INSERT INTO infores_nb.SYS_RES_LOG(OPER_ID,TABLE_NAME,FIELD_NAME,RECORD_ID,OLD_VALUE,NEW_VALUE,OPER_TYPE)      VALUES(vOperID,'SYS_CONFIG','CONFIGTYPE',:old."KEYID",:old."CONFIGTYPE",NULL,'D');    END IF;  END IF;  IF PK_SYSRESLOG.g_UserCode IS NOT NULL THEN    INSERT INTO infores_nb.SYS_RES_OPERLOG(CLIENT_IP,USER_CODE,CLIENT,USER_NAME,ENTITY_TYPE,ENTITY_ID,ENTITY_CODE,OPER_TYPE,OPER_TIME,OPER_ID,RUN_PROGRAM,OS_USER)    VALUES(PK_SYSRESLOG.g_ClientIP,PK_SYSRESLOG.g_UserCode,PK_SYSRESLOG.g_Client,PK_SYSRESLOG.g_UserName,'系统配置表',:new."KEYID",:new."NAME",vOperaID,SysDate,vOperID,vRunProgram,vosuser);  ELSE    INSERT INTO infores_nb.SYS_RES_OPERLOG(CLIENT_IP,USER_CODE,CLIENT,USER_NAME,ENTITY_TYPE,ENTITY_ID,ENTITY_CODE,OPER_TYPE,OPER_TIME,OPER_ID,RUN_PROGRAM,OS_USER)    VALUES(vIpAddress,PK_SYSRESLOG.g_UserCode,vMachine,PK_SYSRESLOG.g_UserName,'系统配置表',:new."KEYID",:new."NAME",vOperaID,SYSDATE,vOperID,vRunProgram,vosuser);  END IF;END IF;END;