Declaring Output Parameters

From InterBase
Jump to: navigation, search

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 data_type [, var data_type …])]
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.