Question

oracle中触发器的问题，请教一下，谢谢！

SQL> create or replace trigger tg9
2 after insert or delete or update on employees
3 begin
4 if to_char(sysdate,'DY') in ('SAT','SUN') then
5 raise_application_error(-20500,'Can't operate i weekend);
6 end if;
7 end tg9;
8 /

警告: 创建的触发器带有编译错误。

SQL> show errror;
SP2-0158: 未知的 SHOW 选项 "errror"
SQL> show error;
TRIGGER TG9 出现错误:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/38 PLS-00103: 出现符号 "T"在需要下列之一时：
) , * & | = - + < / > at in
is mod remainder not rem => .. <an exponent (**)>
<> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_
between || multiset member SUBMULTISET_

Answer 1

raise_application_error(-20500,'Can't operate i weekend);
错了，'can't 意思是字符can 加上了变量t 所以要你加||符合。

建议改为：
raise_application_error(-20500,'Can not operate i weekend');

Answer 2

你把自定义异常那，里面的字符串给改一下，can后面有个‘，这样是不行的