|Problem with Recompiling Invalid PLSQL Objects(ORA-04068) [message #187741]
||Tue, 15 August 2006 05:51
Registered: September 2005
I have a script which will end with the execution of a procedure PR_REBUILDVIEWS (This procedure refresh the building of views in the database).|
when this script executed it return the following error:
ORA-04068: existing state of packages has been discarded
ORA-04064: not executed, invalidated procedure "SMS5D01.PR_REBUILDCHANNELVIEWS"
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SMS5D01.PR_REBUILDVIEWS", line 31
ORA-06512: at line 2
well ..the using of the following code will not solve the problem,
i still got that the invalid objects recompiled with errors:
Set heading off;
set feedback off;
set echo off;
Set lines 999;
select 'ALTER ' || OBJECT_TYPE || ' ' || OBJECT_NAME || ' COMPILE REUSE SETTINGS;'
where status = 'INVALID'
and object_type in ('PACKAGE','FUNCTION','PROCEDURE','TRIGGER');
set heading on;
set feedback on;
set echo on;
So..can anyone tell me who can i solve this problem?
[Updated on: Tue, 15 August 2006 05:52]
Report message to a moderator