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;