我声明了一个游标:
Cursor Cur_ad1 IS
select distinct t1.RID from T_LC_allPerson t1
where t1.LCID=:old.LCID and t1.RID=:old.RID and
:old.Ptype in (10,11) and t1.Ptype in (10,11)
编译时出现了上述错误,刚学ORACLE,望各位大虾赐教。
...全文
871打赏收藏
为什么出现‘NEW或OLD引用不允许在表层触发器中’的编译错误
我声明了一个游标: Cursor Cur_ad1 IS select distinct t1.RID from T_LC_allPerson t1 where t1.LCID=:old.LCID and t1.RID=:old.RID and :old.Ptype in (10,11) and t1.Ptype in (10,11) 编译时出现了上述错误,刚学ORACLE,望各位大虾赐教。