Commented by: @asfernandes

Your logic is not correct. Why would you assume that procedure not found error *must* be before compile the body?

Commented by: Mustafa YILMAZ (myilmaz)

PROCEDURE short sample but real problem with TRIGGERs
long sample:

CREATE TABLE TESTT
(
FIELD1 INTEGER
);

COMMIT;

CREATE EXCEPTION NOTMODIFY 'not modify';
COMMIT;

SET TERM ^ ;

CREATE TRIGGER TEST_BU FOR TESTT
BEFORE UPDATE
AS
BEGIN
IF (NEW.FIELD1 <> NEW.FIELD1) THEN -- simple copy paste problem second NEW must be OLD
EXCEPTION NOTMODIFY;
END ^

COMMIT ^

ALTER TRIGGER TEST_B
AS
BEGIN
IF (NEW.FIELD1 <> OLD.FIELD1) THEN -- fix field name problem but trigger name misspelling, correct TEST_BU
EXCEPTION NOTMODIFY;
END ^

now error:
Column unknown
NEW.FIELD1
At line 4, column 11

but I am sure FIELD1 exists in TESTT
error message not help

Commented by: Paulius Pazera (ppazera)

I agree that current 'column unknown' error (when such column actually exists) is wrong and misleading (when altering non-existing trigger)

Commented by: @pcisar

Test created.