SYS.DB_OBJECT_CACHE PKG ORA-00913: too many values
hello guru,
I upgraded my database from 10.1.0.5 to 11.2.0.3.3 then I see this next error :
SYS.DB_OBJECT_CACHE PKG ORA-00913: too many values.
thanks for your help.
Jean-Pierre
I executed this next and i do not understand very good what I have to execute.
alter package sys.DB_OBJECT_CACHE_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
4
SQL> show error
Errors for PACKAGE BODY SYS.DB_OBJECT_CACHE_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
14/3 PL/SQL: SQL Statement ignored
14/15 PL/SQL: ORA-00913: too many values
SQL> select text from dba_errors where name ='DB_OBJECT_CACHE_PKG' and owner='SYS';
I upgraded my database from 10.1.0.5 to 11.2.0.3.3 then I see this next error :
SYS.DB_OBJECT_CACHE PKG ORA-00913: too many values.
thanks for your help.
Jean-Pierre
I executed this next and i do not understand very good what I have to execute.
alter package sys.DB_OBJECT_CACHE_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
4
SQL> show error
Errors for PACKAGE BODY SYS.DB_OBJECT_CACHE_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
14/3 PL/SQL: SQL Statement ignored
14/15 PL/SQL: ORA-00913: too many values
SQL> select text from dba_errors where name ='DB_OBJECT_CACHE_PKG' and owner='SYS';
0