This is an anonymous procedure, so it has no name : Code Block « PL SQL Programming « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Programming
3. Code Block

SQL> declare
  2    /*
  3     declare local cursors, variables, and methods here,
  4     but you don't need to have a declaration section.
  5    */
  6  begin
  7    -- You write your logic here
  8
  9    null;  -- Ahhh, you've got to have at least one command!
 10  exception
 11    when NO_DATA_FOUND then
 12      raise_application_error(-20000, 'Hey, No Data Found!');
 13  end;
 14  /

PL/SQL procedure successfully completed.

SQL>