日前我建了一个触发器
CREATE OR REPLACE TRIGGER TR_T_MISSIVEARC
AFTER INSERT ON T_MISSIVEARC
FOR EACH ROW
declare
BEGIN
alter index MISSIVEARC_INDX rebuild online PARAMETERS('sync');
END TR_T_MISSIVEARC;出现了如下的错误
Compilation errors for TRIGGER EAIMC.TR_T_MISSIVEARCError: PLS-00103: 出现符号 "ALTER"在需要下列之一时:
begin case declare exit
for goto if loop mod null pragma raise return select update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
Line: 5
Text: alter index MISSIVEARC_INDX rebuild online PARAMETERS('sync');兄弟们过来帮我看一下
CREATE OR REPLACE TRIGGER TR_T_MISSIVEARC
AFTER INSERT ON T_MISSIVEARC
FOR EACH ROW
declare
BEGIN
alter index MISSIVEARC_INDX rebuild online PARAMETERS('sync');
END TR_T_MISSIVEARC;出现了如下的错误
Compilation errors for TRIGGER EAIMC.TR_T_MISSIVEARCError: PLS-00103: 出现符号 "ALTER"在需要下列之一时:
begin case declare exit
for goto if loop mod null pragma raise return select update
while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
Line: 5
Text: alter index MISSIVEARC_INDX rebuild online PARAMETERS('sync');兄弟们过来帮我看一下
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货