The create or replace the trigger tri_ins_smssend
Before the insert on the SEND
For each row
The begin
Then the if: new mobile_to like '0086%'
: new mobile_to:=substr (: new. Mobile_to, 5);
end if;
If: new mobile_to like '+ 86% then
: new mobile_to:=substr (: new. Mobile_to, 4);
end if;
If: new sendflag:=0 then
null;
The else
: new pre_send_time:=(select trunc (sysdate + 1) + 9/24 + 30/(24 * 60) from dual);
end if;
end;
Error:
Compilation errors for the TRIGGER CWXM. TRI_INS_SMSSEND
Error: PLS - 00103: a symbol "=" in need one of the following:
. (* @ % & amp;=- + & lt;/& gt; At the in
Is the mod remainder not rem then & lt; An exponent (* *) & gt;
<> The or!=the or ~=& gt;=& lt;=& lt;> And the or the like like2 like4 likec between
| | indicator multiset member submultiset
Symbol "*"="before you continue has inserted,
The Line: 11
Text: the if: new. Sendflag:=0 then
Error: PLS - 00103: a symbol of "SELECT" when need to be one of the following:
(- + case mod new not
Null & lt; The an identifier>
The continue avg count current exists Max min
The prior SQL stddev sum variance execute forall the merge time
Timestamp interval date
Text: : new pre_send_time:=(select trunc (sysdate + 1) + 9/24 + 30/(24 * 60) from dual);
Error: PLS - 00103: a symbol "), "in need one of the following:
., @. For & lt; The an identifier>
Group having intersects
Minus the order partition start subpartition union where the connect
The sample
The Line: 14
Text: : new pre_send_time:=(select trunc (sysdate + 1) + 9/24 + 30/(24 * 60) from dual);
CodePudding user response:
If: new sendflag:=0 then, remove the colon in front of 0,
If: new sendflag=0 then
CodePudding user response: