For example, we have a database:
CREATE DOMAIN D_SOME AS INTEGER;
CREATE OR ALTER PROCEDURE SP_SOME(
So if we try to change domains name by:
ALTER DOMAIN D_SOME TO D_OTHER;
Then the first execute/commit gives (bugs origin?):
Cannot commit transaction:
table is not defined.
domain D_SOME is not defined.
But the second execute/call succeeds.
After that we have no domain dependency for procedure SP_SOME, also error if try to execute procedure.
Also we can alter domain to its original name - no dependency, but no errors for execute procedure.