Create Procedure Dialog Help

To create a new procedure, invoke Contextual Menu for Database from Schema Editor, go to sub menu Create, and choose Procedure.

• Name - Name of the procedure.
• Function - Defines kind of routine.
• Result Type - Defines datatype of result value (Only for functions).
• Parameters - Defines list of routines parameters.
  • Name - Name of the parameter.
  • Direction - Direction of the parameter (IN/OUT/INOUT).
  • Type - Data type of the parameter.
  • Plus - Add parameter.
  • Minus - Remove selected parameter.
  • Arrows - Change order of parameters.
• Procedure text - body of procedure.
• Preview - Shows SQL query for creation of current routine.