Tell Me
 

Creating an
Anonymous Block: Part 1
Previous previous|next Next Page


Anonymous blocks are unnamed blocks. They are declared inline at the point in an application where they are to be executed and are compiled each time the
application is executed.

Features of Anonymous Blocks

  • Anonymous blocks are not stored in the database, and they are passed to the PL/SQL engine for execution at run time.
  • You will not be able to to invoke or call the block that you wrote earlier because blocks are anonymous and do not exist after they are executed.
  • Anonymous blocks can serve as nested blocks inside procedures, functions, and other anonymous blocks.

Anonymous Block Structure:

[DECLARE]

BEGIN

---Executable Statements---

[EXCEPTION]

END;