oracle ora06544错误

[yc_learn]

create table users(
usid int primary key,
username varchar2(16) not null,
passowrd varchar2(32) not null,
name varchar2(12),
sex varchar2(2) check(sex='1'or sex='2'),
phonenum varchar2(11),
email varchar2(24),
usertype varchar2(2) cheak(usertype in('1','2','3')));


create squence sq_users
minvalue 1
nomaxvalue
start with 1
increment by 1
nocycle
nocache;

create or replace trigger tri_users
before insert on users for each row when(new.usid is null)
begin
select sq_users.nextval into:new.usid from dual;
end;
/
到建立触发器时却报错了 错误是ora06544，困扰了好久，求大家帮忙？

[卖水果的net]

从语法上看不出什么问题，into:new.usid 中间加一个空格试试 into :new.usid

[卖水果的net]

usertype varchar2(2) check(usertype in('1','2','3'))); create sequence sq_users