Hi,

I do not want to bother anybody, I just do not understand Pando's example.

-----------------------------------------------------
create or replace trigger trg_seq_maestra_agregados
before insert on maestra_agregados
for each row
begin
select seq_maestra_agregados.nextval into :new.cod_agregado from dual;
:new.des_agregado := upper(:new.des_agregado);
-------------------------------------------------------------

I do not understand what new.code.agregado means.

If I were to apply to my taks:

------------------------------------------------
begin
select company_name into :new.company_name
from dual;
:new.company_name := upper(:new.company_name);
end;
------------------------------------------------

It is an invalid trigger, and I do not know how to fix it. Can someone please direct me to solve my problem

Thank you

Roman