Declaring Input Parameters

Go Up to The Procedure Header

Use input parameters to pass values from an application to a procedure. Any input parameters are given in a comma-delimited list enclosed in parentheses immediately after the procedure name, as follows:

CREATE PROCEDURE name
(var datatype [, var datatype …])
. . .

Each input 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 of data types. The name of an input parameter need not match the name of any host parameter in the calling program.

Note: No more than 1,400 input parameters can be passed to a stored procedure.