Declaring Output Parameters

Go Up to The Procedure Header

Use output parameters to return values from a procedure to an application. The RETURNS clause in the procedure header specifies a list of output parameters. The syntax of the RETURNS clause is:

...
[RETURNS (var datatype [, var datatype …])]
AS
...

Each output parameter declaration has two parts: a name and a data type. The name of the parameter must be unique within the procedure, and the data type can be any standard SQL data type except arrays.