Bug - trigger script

Toad for Oracle & DevOps Toolkit
1

Hello,

we noticed problem in Toad for Oracle version 15.0.97. Problem is noticable in Schema Browser and Compare Schemas when generating DDL-script for trigger. In some cases, keyword DISABLE is missing, which might cause serious issues if used to create trigger. Here is the testcase:

CREATE TABLE TEST_FOR_TRIG (
COLUMN1 VARCHAR2(32)
);

CREATE TRIGGER TEST_TRIG
AFTER INSERT ON
TEST_FOR_TRIG
FOR EACH ROW
DISABLE
BEGIN
--code goes here
null;
end;

CREATE TRIGGER TEST_TRIG2
AFTER INSERT ON
-- if I put comment here, disable keyword is missing in Schema Browser and Compare Schemas
TEST_FOR_TRIG
FOR EACH ROW
DISABLE
BEGIN
--code goes here
null;
end;

If you open TEST_TRIG2 in schema browser, you will notice that there is no DISABLE-keyword

Regards,

2

Thanks. I can reproduce it and will log it internally. It's too late to fix this for 15.1 but we should be able to fix it for the next version.