2016/10/27日
将本机能正常运行的维修生产日志代码发布到公司内测环境里无法正常运行,报错如下:

execute() - pls–QuartzJob.java–quartzjob 开始执行!
java.sql.SQLException: ORA-06550: 第 1 行, 第 7 列:
PLS-00201: identifier ‘MONITORCHANGEPLS.MCP_ISCHANGE’ must be declared
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
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:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at com.szair.smartme.productlogsys.dao.LogEditDao 85. d o I n H i b e r n a t e ( L o g E d i t D a o . j a v a : 3310 ) a t o r g . s p r i n g f r a m e w o r k . o r m . h i b e r n a t e 3. H i b e r n a t e T e m p l a t e . d o E x e c u t e ( H i b e r n a t e T e m p l a t e . j a v a : 406 ) a t o r g . s p r i n g f r a m e w o r k . o r m . h i b e r n a t e 3. H i b e r n a t e T e m p l a t e . e x e c u t e ( H i b e r n a t e T e m p l a t e . j a v a : 339 ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . d a o . L o g E d i t D a o . g e t C h a n g e V a l u e ( L o g E d i t D a o . j a v a : 3288 ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . d a o . L o g E d i t D a o F a s t C l a s s B y C G L I B e c 6980 f b . i n v o k e ( ) a t n e t . s f . c g l i b . p r o x y . M e t h o d P r o x y . i n v o k e ( M e t h o d P r o x y . j a v a : 191 ) a t o r g . s p r i n g f r a m e w o r k . a o p . f r a m e w o r k . C g l i b 2 A o p P r o x y CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy D y n a m i c A d v i s e d I n t e r c e p t o r . i n t e r c e p t ( C g l i b 2 A o p P r o x y . j a v a : 622 ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . d a o . L o g E d i t D a o E n h a n c e r B y C G L I B e 33 f 2 a d 0. g e t C h a n g e V a l u e ( ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . s e r v i c e . L o g e d i t S e r v e r . g e t C h a n g e V a l u e ( L o g e d i t S e r v e r . j a v a : 1224 ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . s e r v i c e . L o g e d i t S e r v e r F a s t C l a s s B y C G L I B a 3 f 1 c 07 d . i n v o k e ( ) a t n e t . s f . c g l i b . p r o x y . M e t h o d P r o x y . i n v o k e ( M e t h o d P r o x y . j a v a : 191 ) a t o r g . s p r i n g f r a m e w o r k . a o p . f r a m e w o r k . C g l i b 2 A o p P r o x y CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy D y n a m i c A d v i s e d I n t e r c e p t o r . i n t e r c e p t ( C g l i b 2 A o p P r o x y . j a v a : 622 ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . s e r v i c e . L o g e d i t S e r v e r E n h a n c e r B y C G L I B f 4 a 0 e 4 f a . g e t C h a n g e V a l u e ( ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . s e r v i c e . Q u a r t z J o b . e x e c u t e ( Q u a r t z J o b . j a v a : 60 ) a t c o m . s z a i r . s m a r t m e . p r o d u c t l o g s y s . s e r v i c e . Q u a r t z J o b F a s t C l a s s B y C G L I B 29 d c b 96 e . i n v o k e ( ) a t n e t . s f . c g l i b . p r o x y . M e t h o d