Examine these program units:
Which two blocks will execute successfully?
A. BEGIN
My_proc;
END;
B. BEGIN pkg2.proc3; END;
C. BEGIN pkg2.proc2;
END;
D. BEGIN pkg1.proc1a; END;
E. BEGIN pkg1.proc1b; END;
Examine these program units:
Which two blocks will execute successfully?
A. BEGIN
My_proc;
END;
B. BEGIN pkg2.proc3; END;
C. BEGIN pkg2.proc2;
END;
D. BEGIN pkg1.proc1a; END;
E. BEGIN pkg1.proc1b; END;
BC
BC
create or replace noneditionable package pkg1 accessible by (pkg2) is
procedure proc1a;
end pkg1;
/
create or replace noneditionable package body pkg1 is
procedure proc1a is
begin
dbms_output.put_line(‘proc1a’);
end proc1a;
procedure proc1b is
begin
proc1a;
end proc1b;
end pkg1;
/
create or replace noneditionable package pkg2 is
procedure proc2;
procedure proc3;
end pkg2;
/
create or replace noneditionable package body pkg2 is
procedure proc2 is
begin
pkg1.proc1a;
end proc2;
procedure proc3 is
begin
pkg2.proc2;
end proc3;
end pkg2;
/
BEGIN My_proc; END;
/
BEGIN pkg2.proc3; END;
/
BEGIN pkg2.proc2; END;
/
BEGIN pkg1.proc1a; END;
/
BEGIN pkg1.proc1b; END;
/
BC