Examine the following package specification:
Which statement is true?
A. g_comm has a value of 15 at 9: 06 AM only for Jones
B. g_comm has a value of 10 at 9: 03 AM for both Jones and smith
C. g_comm has a value of 15 at 9: 03 AM for both Jones and smith
D. g_comm has a value of 20 at 9: 06 AM for both Jones and smith
Why not B too?
Correct Answer: A
Code for testing (need two sessions):
create or replace package comm_package
is
g_comm number:=10;
procedure reset_comm(p_comm in number);
end comm_package;
/
execute comm_package.g_comm:=15;
exec dbms_output.put_line(comm_package.g_comm);