Start of change

-455 IN CREATE FOR routine-name, THE SCHEMA NAME schema-name1 PROVIDED FOR THE SPECIFIC NAME DOES NOT MATCH THE SCHEMA NAME schema-name2 OF THE ROUTINE

Explanation

If the SPECIFIC name is specified as a two part name, the schema-name1 portion must be the same as the schema-name2 portion of the routine-name. Note that the schema-name2 portion of routine-name might have been specified directly or it might have defaulted to the authorization ID of the statement.

System action

The statement cannot be processed.

Programmer response

Correct the statement.

SQLSTATE

42882

End of change