| Dependency [message #169378] |
Wed, 26 April 2006 08:51  |
ssrividhya
Messages: 8
Registered: April 2006
|
Junior Member |
|
|
CREATE OR REPLACE PROCEDURE calculate_budget IS
v_budget studio.yearly_budget%TYPE;
BEGIN
v_budget := get_budget (11);
IF v_budget < 30000000 THEN
set_budget (11, 300000000);
END IF;
END;
If the GET_BUDGET function is currently marked as invalid, when will it be recompiled implicitly?
a. never, but may be manually recompiled
b. the next time the SET_BUDGET procedure is analyzed
c. the second time the GET_BUDGET function is executed
d. the next time the CALCULATE_BUDGET procedure is executed
|
|
|
|
| Re: Dependency [message #169382 is a reply to message #169378] |
Wed, 26 April 2006 09:12  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
See your other post. Don't start a new thread for each question you have. Take note of those you have problems with and post them in a single thread.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
