|
Block name
|
Type
|
Defined by
|
|
Simple DO block
|
Basic
|
DO statement without either the TRANSACTION option or the ON ERROR phrase
|
|
DO TRANSACTION block
|
Basic
|
DO statement with the TRANSACTION option
|
|
DO ON ERROR block
|
Basic
|
DO statement with the ON ERROR phrase
|
|
FOR block
|
Basic
|
FOR statement
|
|
REPEAT block
|
Basic
|
REPEAT statement
|
|
CATCH block (Structured error handling only)
|
End
|
CATCH statement
|
|
FINALLY block (Traditional and structured error handling)
|
End
|
FINALLY statement
|
|
Procedure (External procedure)
|
Routine-level(File)
|
The implicit all-enclosing block of a procedure file
|
|
Internal procedure
|
Routine-level
|
PROCEDURE statement
|
|
User-defined function
|
Routine-level
|
FUNCTION statement
|
|
Database trigger procedure
|
Routine-level(File)
|
TRIGGER PROCEDURE statement in a procedure file
|
|
Database trigger block
|
Routine-level
|
ON statement with a database event specified
|
|
User-interface trigger
|
Routine-level
|
ON statement with a user-interface event specified
|
|
Class method(User-defined method)
|
Routine-level
|
METHOD statement
|
|
Class constructor
|
Routine-level
|
CONSTRUCTOR statement
|
|
Class destructor
|
Routine-level
|
DESTRUCTOR statement
|
|
Class property accessor
|
Routine-level
|
PROPERTY statement and GET or SET definition
|
|
Class block(Class file)
|
Class(File)
|
CLASS statement in a class file (.cls)
|