-590   NAME name IS NOT UNIQUE IN THE CREATE OR ALTER FOR ROUTINE routine-name

Explanation

The name that is specified for a parameter, SQL variable, cursor, label, or condition in a CREATE or ALTER statement for a routine is not unique.

name
The item name that is not unique within the routine.
routine-name
The name of the routine that contains the duplicate item names.
The value for name must adhere to the following rules:
  • A parameter name must be unique within the parameter list.
  • An SQL variable name must be unique within the compound statement in which it is declared, excluding any declarations within compound statements that are nested within the compound statement that declares the SQL variable.
  • An SQL variable name must not be the same as a parameter name.
  • A cursor name must be unique within the procedure body in which it is declared, excluding any declaration within compound statements that are nested within the compound statement that declares the cursor.
  • A condition name must be unique within the compound statement in which it is declared, excluding any declarations within compound statements that are nested within the compound statement that declares the condition.
  • A label must be unique within a compound statement, including any labels within compound statements that are nested within the compound statement that defines the label.

System action

The statement cannot be processed.

Programmer response

Change the name so that it is unique.

SQLSTATE

42734