PL/SQL (MOSC)

MOSC Banner

who check triggers with error or disable not run in whit aplication

edited Aug 10, 2010 8:12AM in PL/SQL (MOSC) 6 commentsAnswered
 when a trigers this disable or this I invalid like you force to that the application that makes it execute sends error in Version RDBMS 11.1.0.7

there are for moments that it sends the error
ORA-04068: existing state of packages has been discarded <br/>ORA-04061: existing state of package  XXXX has been invalidated <br/>ORA-04065: not executed, altered or dropped package "SYS.DBMS_JOB" <br/>ORA-06508: PL/SQL: could not find program unit being called

Already check the metalink notes 778842.1 and the inconsistency is not presented

set pagesize 10000
column d_name format a20
column p_name format a20
select do.obj# d_obj,do.name d_name, do.type# d_type,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center