DBA Data[Home] [Help]

SYS.VALIDATE_CONTEXT dependencies on DBMS_REGISTRY

Line 78: dbms_registry.invalid('CONTEXT');

74:
75: if l_compile_sql is null then
76: dbms_output.put_line(
77: 'FAILED CHECK FOR '||c1.dbo_type||' '||c1.dbo_name);
78: dbms_registry.invalid('CONTEXT');
79: goto endfunc;
80: else
81: begin
82: execute immediate l_compile_sql;

Line 87: dbms_registry.invalid('CONTEXT');

83: exception
84: when others then
85: dbms_output.put_line(
86: 'FAILED CHECK FOR '||c1.dbo_type||' '||c1.dbo_name);
87: dbms_registry.invalid('CONTEXT');
88: goto endfunc;
89: end;
90: end if;
91: end if;

Line 95: l_upg_mode := sys.dbms_registry.is_in_upgrade_mode();

91: end if;
92: end loop;
93:
94: /* Bug 16936854 : Check if there were any errors during CONTEXT upgrade */
95: l_upg_mode := sys.dbms_registry.is_in_upgrade_mode();
96: if (l_upg_mode = TRUE) then
97: select count(*) into l_errcnt
98: from sys.registry$error
99: where identifier = 'CONTEXT';

Line 101: dbms_registry.invalid('CONTEXT');

97: select count(*) into l_errcnt
98: from sys.registry$error
99: where identifier = 'CONTEXT';
100: if (l_errcnt != 0) then
101: dbms_registry.invalid('CONTEXT');
102: goto endfunc;
103: end if;
104: end if;
105:

Line 106: dbms_registry.valid('CONTEXT');

102: goto endfunc;
103: end if;
104: end if;
105:
106: dbms_registry.valid('CONTEXT');
107:
108: <>
109: null;
110:

Line 114: dbms_registry.invalid('CONTEXT');

110:
111: exception
112: when others then
113: ctxsys.drue.text_on_stack(sqlerrm, 'validate_context');
114: dbms_registry.invalid('CONTEXT');
115: ctxsys.drue.raise;
116: end validate_context;