PLS-00103: 出现符号 "EXCEPTION"在需要下列之一时:
( begin case declare
end exit for goto if loop mod null pragma raise return select
update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
end not pragma
final instantiable order overriding static member constructor
map
( begin case declare
end exit for goto if loop mod null pragma raise return select
update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge
PLS-00103: 出现符号 "end-of-file"在需要下列之一时:
end not pragma
final instantiable order overriding static member constructor
map
照着这个格式改下吧declare
... --定义变量等
begin
... --具体操作等exception when others then
...
end;
l_action :='INSERT';
ELSIF UPDATING THEN
l_action :='UPADTE';
ELSIF DELETING THEN
l_action :='DELETE';
ELSE
RAISE_APPLICATION_ERROR(-20001,'You should never ever get thie error.');
END IF; INSERT INTO R2R.PH_CD_CONFIG_HIST
(
ID,
ACTION,
TARGET_VALUE,
CD_TYPE,
EXPIRED_DAY,
FB_TOOL_GROUP,
JOB_ACTIVE,
OCD_WEIGHT,
CDSEM_WEIGHT,
USER_ID )
VALUES
(
tmpVar,
l_action,
:NEW.TARGET_VALUE,
:NEW.CD_TYPE,
:NEW.EXPIRED_DAY,
:NEW.FB_TOOL_GROUP,
:NEW.JOB_ACTIVE,
:NEW.OCD_WEIGHT,
:NEW.CDSEM_WEIGHT,
:NEW.USER_ID );
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
NULL;
RAISE;
END ;
检查是不是全部配对了
那你执行delete动作的时候,R2R.PH_CD_CONFIG_HIST表中是否会有记录产生?
还是说有一条记录,只是ACTION值为空?
就是在R2R.PH_CD_CONFIG_HIST表中没有记录
IF INSERTING THEN
l_action :='INSERT';
ELSIF UPDATING THEN
l_action :='UPADTE';
ELSE
l_action :='DELETE';
END IF;