Explain IN, OUT and INOUT in procedures.

Answer

IN, OUT and INOUT are the arguments that are passed to the procedures.

* IN is a 'read only' argument and must be initialised.

* OUT is an uninitialised argument which must be initialized by a function.

* INOUT - A combination of the two above. That is, an initialised argument which can be written to.