Procedures are reusable processing blocks that are implemented using the SQLscript, which describes a sequence of operations on data passed as input and database tables. It can be created as read-only (without side-effects) or read-write (with side-effects).
Procedures can have multiple input parameters and output parameters (can be scalar or table types).
There are three different ways to create a procedure in HANA:
The following syntax is used to create ...