-078   PARAMETER NAMES MUST BE SPECIFIED FOR ROUTINE routine-name

Explanation

The routine does not have parameter names specified for all parameters.

routine-name
The name of the routine.

When the SQL routine is defined with LANGUAGE SQL, a parameter name is required for each parameter that is defined. For native SQL procedures, LANGUAGE SQL is optional, but for external SQL procedures, LANGUAGE SQL is required.

System action

The statement cannot be processed.

Programmer response

Ensure that each defined parameter includes a parameter name.

SQLSTATE

42629