DROP PROCEDURE statement fails with “Failure to acquire exclusive schema lock for DDL operation. (7872)” error.
The DROP PROCEDURE statement will fail with a “Failure to acquire exclusive schema lock for DDL operation. (7872)” error if any 4GL or SQL client application connected to the database and accessed any table records even with NO-LOCK.