CREATE OR REPLACE TRIGGER MSG.uppurworkbuyer
AFTER INSERT
on "MSG"."HOLA_APP_NT_PURWORK"
for each row
begin
if BUYER is null
update table HOLA_APP_NT_PURWORK
set BUYER =
(select ORG_CODE from org_position where emp_id = (select REQEMPID from HOLA_APP_NT_PURREQ where REQID =:OLD.REQID ))
where PURWORKID =:OLD.PURWORKID
end if
end;生成触发器之后有一个警告:
PLS-00103: 出现符号 "UPDATE"在需要下列之一时: then and or
@@ 一直没有搞定 请大家帮忙看看啊
解决方案 »
- orale对象及数据转移?
- 在线求助,按格式输出数据的问题
- 请问怎么样用JAVA编写监控ORACLE是否在运行,以及怎么样获得当前的基本性能参数??
- 在EXEC SQL BEGIN DECLARE SECTION 中定义的char 类型数组的问题?为什么char sSQL[SQL_LEN]这样定义会抱错?
- 问高手关于TO_DATE函数的问题。在线急等
- ~~~碰到难题了,再做不出来,老板逼我从金茂大厦上跳下来了!!!求求你们救救我吧~~~~~~
- 关于oracle定时任务的问题
- procedure的调用,执行问题。
- proc高手请入!proc访问oracle8.1.7汉字显示不正确!!!!
- 查询语句的优化问题...该用不用临时表?
- 高分求教一个字符串验证的问题!
- 触发器UPDATE 的时候 有简洁的方法没
AFTER INSERT
on "MSG"."HOLA_APP_NT_PURWORK"
for each row
begin
if BUYER is null then
update table HOLA_APP_NT_PURWORK
set BUYER =
(select ORG_CODE from org_position where emp_id = (select REQEMPID from HOLA_APP_NT_PURREQ where REQID =:OLD.REQID ))
where PURWORKID =:OLD.PURWORKID
end if
end;
AFTER INSERT
on MSG.HOLA_APP_NT_PURWORK
for each row
begin
if :old.BUYER is null then
update HOLA_APP_NT_PURWORK
set BUYER =
(select ORG_CODE from org_position where emp_id = (select REQEMPID from HOLA_APP_NT_PURREQ where REQID =:OLD.REQID ))
where PURWORKID =:OLD.PURWORKID;
end if;
end;
CREATE OR REPLACE TRIGGER MSG.uppurworkbuyer
AFTER INSERT
on "MSG"."HOLA_APP_NT_PURWORK"
for each row
begin
if BUYER is null then --不是提示你少 then了吗
update table HOLA_APP_NT_PURWORK
set BUYER =
(select ORG_CODE from org_position t where exists (select 1 from HOLA_APP_NT_PURREQ where t.emp_id=REQEMPID and REQID =:OLD.REQID ))
where PURWORKID =:OLD.PURWORKID ;
end if;
end;
PLS-00103: 出现符号 "UPDATE"在需要下列之一时: then and orif BUYER is null then where PURWORKID =:OLD.PURWORKID ;
end if;
AFTER INSERT
on "MSG"."HOLA_APP_NT_PURWORK"
for each row
begin
if :new.BUYER is null
update table HOLA_APP_NT_PURWORK
set BUYER =
(select ORG_CODE from org_position where emp_id = (select REQEMPID from HOLA_APP_NT_PURREQ where REQID =:new.REQID ))
where PURWORKID =:new.PURWORKID
end if
end;insert类型的trigger :old没意义的.
if BUYER is null then where PURWORKID =:new.PURWORKID ;
end if;