我创建了一个空触发器,可是当像这个表插入数据时显示“触发器无效且未通过重新确认”
这是哪里写错了,请高手指教。
create or replace trigger tri_pingfen_gameinfo
before insert
on tb_game_info
for each row
begin
end
这是哪里写错了,请高手指教。
create or replace trigger tri_pingfen_gameinfo
before insert
on tb_game_info
for each row
begin
end
after insert or update or delete
on xxx
for each row
declare
v_Old varchar2(4000);
begin
if inserting then
...
end if;
if updating then
...
end if;
if deleting then
...
end if;
end tri_xxx;
CREATE OR REPLACE TRIGGER tri_pingfen_gameinfo
before insert
on tb_game_info
for each row
DECLARE
tmp_sql VARCHAR2(50);begin
select sysdate into tmp_sql from dual;
end;
/