-4758 INVALID SPECIFICATION ON CREATE STATEMENT. (REASON CODE reason-code)
Explanation
The CREATE PROCEDURE statement included an invalid specification. This error is issued for the situation identified by the reason code.- reason-code
- 01
- The SPECIFIC clause was specified with a value that is not the same as the procedure name. The specific name for a procedure must be the same as the procedure name.
- 02
- A CREATE statement with an OR REPLACE clause attempted to replace an existing procedure. A procedure with the same name exists, but is a different type of procedure than what is specified in the CREATE statement. An external procedure can only be replaced if the new definition is also for an external procedure. Likewise, a native SQL procedure can only be replaced if the new definition is also for a native SQL procedure.
- 03
- A CREATE statement with an OR REPLACE or SPECIFIC clause was specified on a CREATE PROCEDURE statement for an external SQL procedure.
System action
The SQL statement cannot be executed.
Programmer response
Correct the identified problem with the statement and retry the statement.SQLSTATE
530A3
