It has been recommended to move trigger code to stored procedures when the code gets large. We would hence create a procedure (stand-alone or inside a package) as
PROCEDURE p_handle_mytable (vi_old mytable%ROWTYPE, vi_new mytable%ROWTYPE) AS ...
Unfortunately, though, we cannot simply
CREATE OR REPLACE TRIGGER trg_mytable AFTER DELETE OR INSERT OR UPDATE ON mytable FOR EACH ROW BEGIN p_handle_mytable (:old, :new); END;
although this is PL/SQL code and :old and :new seem to work exactly as if defined as mytable%rowtype elsewise.
My request: Treat :old and :new as ROWTYPE and make it thus possible to pass :old and :new to a procedure.
(Sorry, if this idea has been suggested before. I've not been able to properly search database ideas in the new forum. Hence I do not know whether this idea has already been proposed.)
If you would like to receive notifications of new posts and discussion on this forum, you will need to:
1. Go to https://community.oracle.com/tech/apps-infra/categories/intelligent_advisor_-_general_discussion and hit the Follow button (it will say "Following" once you have done this).
2. Go to your notification preferences and enable notifications for the Industry Applications category.