Consider the following scenario:
Local procedure a calls remote procedure B
Procedure A was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.
The dependency mode is set to timestamp.
Which statement correctly describes what happens when procedure A is invoked at 1 PM?
A.
Procedure A is invalidated and recompiled immediately.
B.
There is no effect on procedure A and it runs successfully.
C.
Procedure B is invalidated and recompiled again when invoked.
D.
Procedure A is invalidated and recompiles when invoked the next time.
D
D
d
D
Why D?
D
Time-Stamp Checking:
The local procedure will invalidated if any time stamps of remotely referenced procedures do not match, and an error will be returned
https://docs.oracle.com/cd/B28359_01/server.111/b28318/dependencies.htm#i1365
D
“The remote dependency mechanism is different from the automatic local dependency mechanism
already discussed. The first time a recompiled remote subprogram is invoked by a local
subprogram, you get an execution error and the local subprogram is invalidated; the second time it is invoked, implicit automatic recompilation takes place.”
Source: http://power2.offis.uni-oldenburg.de:7777/sqlkurs/unterlagen_plsql/pdf/ManagingDependencies.PDF
Page: 18
Correct answer is D