还没有环境测试,估计不能用整个对象列来作插入条件.如:
create or replace type nested as object(
id varchar2(1),
name varchar2(10));那触发器要具体到某一列上create trigger table_t
before insert of nested.id
on table
begin
………………
end;
楼主不防测试吧
create or replace type nested as object(
id varchar2(1),
name varchar2(10));那触发器要具体到某一列上create trigger table_t
before insert of nested.id
on table
begin
………………
end;
楼主不防测试吧
create trigger table_t
before insert of nested.id
on table
begin
………………
end;
before insert of nested
*
ERROR 位于第 2 行:
ORA-04073: 此触发器类型的列列表无效create trigger table_t
before insert of table.nested.id
on table
begin
………………
end;
before insert of nested
*
ERROR 位于第 2 行:
ORA-04073: 此触发器类型的列列表无效