Toad World® Forums

CodeXpert - why reports LABEL violation for TRIGGER?

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 …

Can anyone tell me if the above described problem still occurs the newest version (11.0) by using the provided code example?

Thanks a lot …

Hi Andreas,

Today we are at Toad 11.5, the former CodeXpert has been replaced by thenew Code Analysis engine which - as I wrote in my previous post - uses an entirely different technology.

Of course we highly appreciate your feedback but it really should be based on 11.5 in order to be effective.

Thanks,
Andre

Hi Andre,

thanks for your feedback. It is, though, not clear for me if the above false positive is fixed in 11.5 or not?

Cheers,
Andreas