CREATE PROCEDURE is used to create a stored procedure. For details on how to use CREATE PROCEDURE to create a procedure, see the manual HiRDB Version 8 UAP Development Guide.
CREATE FUNCTION is used to create a stored function. For details on how to use CREATE FUNCTION to create a function, see the manual HiRDB Version 8 UAP Development Guide.
When a stored function is created, an existing stored function may become invalid. An existing stored function that satisfies the following condition becomes invalid:
In this case, use ALTER ROUTINE to re-create the invalidated stored function.
When a stored function is created, an existing stored procedure may become invalid. An existing stored procedure that satisfies the following condition becomes invalid:
In this case, use the ALTER PROCEDURE statement or ALTER ROUTINE to re-create the invalidated stored procedure.
When a stored function is created, an existing trigger may become invalid. An existing trigger that satisfies the following condition becomes invalid:
In this case, use the ALTER TRIGGER statement or ALTER ROUTINE to re-create the invalidated trigger.
A stored function created using the following procedure may become invalid: