Home » Other » Training & Certification » Dependency
Dependency [message #169378] Wed, 26 April 2006 08:51 Go to next message
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 Go to previous message
Maaher
Messages: 7062
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
Previous Topic: Pl answer these questions
Next Topic: Any Good Oracle Apps CRM Functional Training Institute in USA, Please Guide!!
Goto Forum:
  


Current Time: Tue Oct 27 19:41:23 CDT 2020