|
-
Hello all, thanks for your comments to date... but I am still doing something wrong? My trigger is:
CREATE OR REPLACE TRIGGER "GSUSER"."XBENEFIT" BEFORE DELETE ON "GSUSER"."BENEFIT"
REFERENCING OLD AS old NEW AS new
FOR EACH ROW BEGIN
INSERT INTO xBenefit (
Benefit,
SortOrder,
CreatedUser,
CreatedDT,
UpdatedUser,
UpdatedDT
)
VALUES (
old.Benefit,
old.SortOrder,
old.CreatedUser,
old.CreatedDT,
old.UpdatedUser,
old.UpdatedDT
);
COMMIT;
END xClient;
I'm getting a compile error on this... "Identifier 'OLD.ENEFIT' must be declared." Could anyone suggest what I've done wrong please?
MTIA
Max Hugen
Hugen Enterprises Pty Ltd
www.hugen.com.au
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|