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;
/
Help in Trigger
-
- Rank: Estagiário Sênior
- Posts: 12
- Joined: Wed, 22 Aug 2007 4:58 pm
- Location: rio de janeiro
Friends can someone help with this trigger here ???? This is invalidated in the compilation
-
- Rank: Estagiário Sênior
- Posts: 12
- Joined: Wed, 22 Aug 2007 4:58 pm
- Location: rio de janeiro
Look at the error
Compilation Errors for Trigger to inactivate
Compilation Errors for Trigger to inactivate
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;
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Brother,
The New AS Reference New and Old Old is correct?
The New AS Reference New and Old Old is correct?
-
- Rank: Programador Sênior
- Posts: 60
- Joined: Tue, 17 Jan 2006 1:45 pm
- Location: Santa Catarina
Att.:
Alan Juliano Metzger
Programador Oracle
Inside System Informática
Msn/E-mail: alanjuliano@yahoo.com.br
Alan Juliano Metzger
Programador Oracle
Inside System Informática
Msn/E-mail: alanjuliano@yahoo.com.br
I think I found the problem missing the two points in front of the new and old.
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.
if :new.in_servico_inibido = 1 then
-
- Rank: Estagiário Sênior
- Posts: 12
- Joined: Wed, 22 Aug 2007 4:58 pm
- Location: rio de janeiro
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
("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")
end if
end
-
- Rank: Estagiário Sênior
- Posts: 12
- Joined: Wed, 22 Aug 2007 4:58 pm
- Location: rio de janeiro
Srs was like this:
SRS I am sending the trigger script that makes control of the fields inhibited and active:
SRS I am sending the trigger script that makes control of the fields inhibited and active:
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 ;
-
- Information
-
Who is online
Users browsing this forum: Bing [Bot] and 1 guest