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.