alter session set Plsql_Warnings = 'Enable:All' create procedure p1 authid definer is
loop number;
begin
Sys.DBMS_Output.Put_Line('
Never try reason about a program whose whole effect is "null".
The optimizer might subvert the intention in your head because
you told it "I do not care what this program does."');
end p1; begin p1(); end; create procedure p2 authid definer is
if number;
begin
Sys.DBMS_Output.Put_Line('This is p2');
end p2;create procedure p3 authid definer is
begin
<<dog>>begin
Sys.DBMS_Output.Put_Line('This is p3');
end cat;
end p3; begin p3(); end; create procedure playingWithCamels authid definer is
begin
Sys.DBMS_Output.Put_Line('I hate playing with camels');
end "PLAYINGWITHCAMELS"; begin "PLAYINGWITHCAMELS"(); end;