alter session set Plsql_Warnings = 'Enable:All' Statement processed.
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; Warning: PROCEDURE P1 Line: 2 PLW-06010: keyword "LOOP" used as a defined nameMore Details: https://docs.oracle.com/error-help/db/ora-20001
begin p1(); end;
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."
create procedure p2 authid definer is
if number;
begin
Sys.DBMS_Output.Put_Line('This is p2');
end p2;Errors: PROCEDURE P2 Line: 2 PLS-00103: Encountered the symbol "IF" when expecting one of the following: begin function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior external languageMore Details: https://docs.oracle.com/error-help/db/ora-24344
create procedure p3 authid definer is
begin
<<dog>>begin
Sys.DBMS_Output.Put_Line('This is p3');
end cat;
end p3; Procedure created.
begin p3(); end; This is p3
create procedure playingWithCamels authid definer is
begin
Sys.DBMS_Output.Put_Line('I hate playing with camels');
end "PLAYINGWITHCAMELS"; Procedure created.
begin "PLAYINGWITHCAMELS"(); end; I hate playing with camels