CodeXpert reports me “Label - Ensure block starting and ending labels match or block label is not missing (Toad 10)” for the simple trigger below. Is this a bug and if yes, where can I open a bug issue?
{code}
CREATE OR REPLACE TRIGGER LABEL_TEST_EXAMPLE
AFTER UPDATE OF SURNAME, FIRSTNAME
ON T_PERSON
REFERENCING NEW AS row_new OLD AS row_old
FOR EACH ROW
WHEN (NVL (row_new.SURNAME, ‘’) <> NVL (row_old.SURNAME, ‘’)
OR NVL (row_new.FIRSTNAME, ‘’) <> NVL (row_old.FIRSTNAME, ‘’))
BEGIN
UPDATE T_PERSON p
SET p.LAST_CHANGED = SYSDATE
WHERE p.PERSON_ID = :row_old.PERSON_ID;
END LABEL_TEST_EXAMPLE;
/
{code}
I am using Toad 9.7.2.5.
Thank you for your help …