"Dependencies broken" if trying to alter procedure used in a view

[mg-ica]

When trying to alter the body of a procedure which is used in a view i get an error message "Dependencies broken".

Using isql this works without any problem.

FB 2.5.9

[arvanus]

Can you provide a reproducible sample?

[mg-ica]

The following code causes this behavior every time. Without the intermediate COMMITs it's working

SET TERM ^ ;
CREATE PROCEDURE SP_TEST
RETURNS (X VARCHAR(8))
AS
BEGIN
  X = '1';
  SUSPEND;
END
^
SET TERM ; ^

COMMIT;

CREATE VIEW VIEW_TEST(Y)
AS
SELECT (SELECT X FROM SP_TEST) AS Y FROM RDB$DATABASE;

COMMIT;

SET TERM ^ ;
ALTER PROCEDURE SP_TEST
RETURNS (X VARCHAR(8))
AS
BEGIN
  X = '2';
  SUSPEND;
END
^
SET TERM ; ^