When an ALTER PROCEDURE request is performed, the system places an EXCLUSIVE lock on the corresponding procedure table in the database. The procedure is unavailable to other users during the recompilation time.
When an ALTER PROCEDURE request is performed, the system places an EXCLUSIVE lock on the corresponding procedure table in the database. The procedure is unavailable to other users during the recompilation time.