Help in Trigger

[fabiopdb]

Friends can someone help with this trigger here ???? This is invalidated in the compilation

Select all

create or replace trigger inativar 
after update on tab_servico 
for each row 
begin 
  if inserting or updating then 
    if new.in_servico_inibido = 1 then 
    new.in_ativo := 0 
    end if 
  end if; 
end inativo; 
/

[dr_gori]

I think the problem is that inactive end;
Take the inactive!

[fabiopdb]

I took the inactive and still was not ...

[fabiopdb]

Look at the error

Compilation Errors for Trigger to inactivate

Select all

Error: PLS-00103: Encontrado o símbolo "END" quando um dos seguintes símbolos era esperado:* & = - + ; < / > at in is mod remainder not rem 
<um expoente (**)> <> or != or ~= >= <= <> and or like LIKE2_ 
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ O símbolo ";" foi substituído por "END" para continuar. 
Line: 8 
Text: end if;

[Trevisolli]

Brother,

The New AS Reference New and Old Old is correct?

[meguelito]

I think I found the problem missing the two points in front of the new and old.

Select all

if :new.in_servico_inibido = 1 then

And another thing try to take the point and comma from the end or leave only end but I think the problem is the two points.

[fabiopdb]

Select all

create or replace trigger inativar 
after update on tab_servico 
for each row 
begin 
if  inserting or updating then 
if:new.in_servico_inibido = 1 then 
new.in_ativo := 0 
end if

is stopping here

Select all

 ("Compilation errors for TRIGGER ACQUA_USER.INATIVAR Error: PLS-00103: Encontrado o símbolo "END" quando um dos seguintes símbolos era esperado:* & = - + ; < / > at in is mod remainder not rem 
  (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_Line: 8 Text: end if")

Select all

end if 
end

[fabiopdb]

Srs was like this:
SRS I am sending the trigger script that makes control of the fields inhibited and active:

Select all

create or replace trigger inativar 
after update on tab_servico 
REFERENCING OLD AS old NEW AS new 
for each row 
begin 
if inserting or updating then 
if:new.in_servico_inibido = 1 then 
update tab_servico set in_ativo = 0 ; 
end if; 
end if; 
end ;

[dr_gori]

beleza, hehehe
was ; after endif -> no one saw !!