Toad World® Forums

Toad Edge Preview problems showing triggers


#1

The preview can not show correctly some of our triggers.

The trigger is like this (PEM-client):
CREATE OR REPLACE TRIGGER test_trigger_briu
BEFORE INSERT OR UPDATE
ON kari1
FOR EACH ROW
BEGIN
IF INSERTING THEN
mgr.check(NULL, NULL, NULL, :new.name, :new.date, :new.counter);
END IF;
IF UPDATING THEN
mgr.check(:old.name,:old.date, :old.counter, :new.name, :new.date, :new.counter);
END IF;
END;

Toad Edge shows this trigger source like this:
CREATE TRIGGER test_trigger_briu
BEFORE UPDATE OR INSERT
ON karischema.kari1
FOR EACH ROW
EXECUTE PROCEDURE test_trigger_briu_kari1 ()


#2

Hello Kari,

the output you see is correct one. When creating trigger DB automatically creates trigger function, in this case test_trigger_briu_kari1. Toad Edge shows content of this function under trigger functions node in Object Explorer. And reference to it in the trigger.

We can consider adding source of the referenced procedure into the trigger definition as an option if it is something you would appreciate.

Regards

Petr Chudanic