SQL & PL/SQL

Hi everyone,

I wonder, if someone would help me in trigger's implementation. My use case the following:

- fire a trigger after each INSERT or UPDATE operation;
- use FOR EACH ROW algorithm for a trigger;
- collect some values of inserted/updated fields like :new.uuid and store them into a global collection defined on the package's layer;
- only for the last inserted/updated row call a procedure passing the global collection with collected values as a parameter;

Is it possible to implement for the FOR EACH ROW's type of trigger? Does a :new identifier or trigger itself have special attributes like COUNT, SIZE for defining a size of inserted/modified data for a conditional logic? Are there another possible workaround for considered use case.

Thanks,

Andrey