Howdy!
When altering (and presumably creating) a trigger in another schema using the SB to have a FOLLOWS clause, Toad correctly shows the existing triggers to be selected to follow, but does not put the schema name in the SQL.
So, this trigger fragment:
CREATE OR REPLACE TRIGGER OTHERSCHEMA.BLEAH_IU
BEFORE INSERT OR UPDATE
ON OTHERSCHEMA.BLEAH
FOR EACH ROW
FOLLOWS BLEAH_ID
BEGIN
...should be:
CREATE OR REPLACE TRIGGER OTHERSCHEMA.BLEAH_IU
BEFORE INSERT OR UPDATE
ON OTHERSCHEMA.BLEAH
FOR EACH ROW
FOLLOWS OTHERSCHEMA.BLEAH_ID
BEGIN
Thanks!
Rich
p.s. In Toad 13.2.0.151, but I didna check older versions.