-590 NAME name IS NOT UNIQUE IN THE CREATE OR ALTER FOR ROUTINE OR TRIGGER object-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 or advanced trigger is not unique.
- name
- The item name that is not unique within the routine or trigger.
- object-name
- The name of the routine or trigger 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 routine or trigger 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