一个触发器语法的问题。

[fdxhappy]

create trigger tgr_inst
on yw_send_document
after insert
as
declare A1 varchar(10)
begin
select name into A1 form yw_name where type='0';
update Table_name set type=type+1;
update Table_name set type=0 where type=(select max(type) from Table_name);
:new.c_typer:=A1;
end
这里哪里有问题，为何运行时候有错误，谢谢！
错误为：缺少 BEFORE, AFTER 或 INSTEAD OF 关键字

[bzszp]

after insert
on yw_send_document

[fdxhappy]

我做了上面的修改了，为何创建完成以后触发器的状态还是invalid了

[bzszp]

编已有什么错误？
show error命令查看一下，贴出来

[fdxhappy]

create trigger name_triger
before insert
on basehb.yw_send_document
declare A1 varchar(10)
begin
select name into A1 from basehb.yw_name where type='0';
update Table_name set type=type+1;
update Table_name set type=0 where type=(select max(type) from Table_name);
:new.c_typer:=A1;
end

警告: 创建的触发器带有编译错误。
show error

TRIGGER NAME_TRIGER 出现错误:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PLS-00103: 出现符号 "BEGIN"在需要下列之一时：
:=;notnulldefault
character
啥意思

[jiezhi]

declare A1 varchar(10);
少了;

[bzszp]

create trigger name_triger
before insert
on basehb.yw_send_document
declare A1 varchar(10)
begin
select name into A1 from basehb.yw_name where type='0';
update Table_name set type=type+1;
update Table_name set type=0 where type=(select max(type) from Table_name);
:new.c_typer:=A1;
end；
/

[fdxhappy]

还是不行呀，大哥，你这个也有语法错误

[beckhambobo]

create trigger name_triger
before insert on basehb.yw_send_document
for each row --行级别
declare
A1 varchar2(10);
begin
select name into A1 from basehb.yw_name where type='0';
update Table_name set type=type+1;
update Table_name set type=0 where type=(select max(type) from Table_name);
:new.c_typer:=A1;
end；
/

[keyset]

赋值语句是这样:
set type := type+1;
set type := 0;