Hi Chris,
I have recompiled all database objects .. and now it is stopping OAS with log message as
jvm 1 | 2008/02/29 16:17:36 | java.sql.SQLException: ORA-06550: line 1, column 7:
INFO | jvm 1 | 2008/02/29 16:17:36 | PLS-00201: identifier 'VPD.SET_USER' must be declared
INFO | jvm 1 | 2008/02/29 16:17:36 | ORA-06550: line 1, column 7:
INFO | jvm 1 | 2008/02/29 16:17:36 | PL/SQL: Statement ignored
INFO | jvm 1 | 2008/02/29 16:17:36 |
INFO | jvm 1 | 2008/02/29 16:17:36 |
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 java.sql.SQLException: ORA-06550: line 1, column 7:
INFO | jvm 1 | 2008/02/29 16:17:36 | PLS-00201: identifier 'VPD.SET_USER' must be declared
INFO | jvm 1 | 2008/02/29 16:17:36 | ORA-06550: line 1, column 7:
INFO | jvm 1 | 2008/02/29 16:17:36 | PL/SQL: Statement ignored
INFO | jvm 1 | 2008/02/29 16:17:36 |
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:13
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:316)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:282)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 639)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4 CCallableStatement.java:184)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.T4CCallableStatement.execute_fo r_rows(T4CCallableStatement.java:873)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1161)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3001)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:3093)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at oracle.jdbc.driver.OracleCallableStatement.execute (OracleCallableStatement.java:4286)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.jdbc.SqlCall.execute(SqlCall.java:59)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.jdbc.SqlCall.execute(SqlCall.java:96)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.database.vpd.VPD.setUser(VPD.java:24)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.jdbc.noserver.T2SharedConnection.setUser (T2SharedConnection.java:226)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.datasource.ConnectionEstablisher.setVpdU ser(ConnectionEstablisher.java:2
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.datasource.GC3ConnectionEstablisher.conn ect(GC3ConnectionEstablisher.java:45)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.datasource.DataSource.reserve(DataSource .java:14
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.datasource.DataSource.reserve(DataSource .java:137)
INFO | jvm 1 | 2008/02/29 16:17:36 | 08/02/29 16:17:36 at glog.util.jdbc.noserver.T2SharedConnection$Referen cedConnection.addRef
Can you please help me ..
Thanks,
Naveen