| its urgent please [message #306383] |
Fri, 14 March 2008 00:11  |
toufiq_raja
Messages: 39
Registered: May 2005
Location: Islamabad
|
Member |
|
|
someone accediently executed CATPROC script in his DBA privileged schema (PROG3). since then while compiling forms following error stack is arising:
1.
ORA-04029 error ORA-942 occured when quering ORA_KGLR7_DEPENDENCIES
ORA-00604 error ocured at recursive SQL level 1
ORA-00942 table or view does not exist
2. when i try to connect SQLPLUSW, it connects to schema but with following error :
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
3. while dropping a user :
drop user prog3 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, stored procedure "PROG3.DICTIONARY_OBJ_TYPE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
