Re: CodeXpert - why reports LABEL violation for TRIGGER?
Andre Vergison <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <25037680.75491334777122546.JavaMail.SYSTEM@alvqcfw02> |
Message from: avergison
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
_______________________________________
Historical Messages
Author: Andre Vergison
Date: Wed Apr 18 12:24:51 PDT 2012
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
__
Author: Andreas Schmid
Date: Tue Apr 10 04:26:43 PDT 2012
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 ...
__
Author: Andreas Schmid
Date: Tue Apr 03 08:19:09 PDT 2012
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 ...
__
_______________________________________