oracle触发器问题
create table BOOK_INFO(
"auto_id" number(20) not null primary key,
"title" varchar2(500) not null,
"author" varchar2(500) not null,
"price" number(10,2),
"press" varchar2(500),
"publishdate" Date
);
-----------
create sequence book_info_seq
increment by 1
start with 1
nomaxvalue
nocycle
cache 10;
-------------
create or replace trigger addBook_Info
before insert on BOOK_INFO
for each row
begin
select book_info_seq.nextval into :new.auto_id from dual;
end;
错误：PLS-00049: bad bind variable 'NEW.AUTO_ID'
文本：select book_info_seq.nextval into:new.auto_id from dual;
麻烦各位帮忙看下，麻烦在PL/SQL测试下，谢谢！不知道错哪里了，分有点少，望谅解。
[解决办法]
mysql_query("set names gb2312;");
[解决办法]
REFERENCING NEW new
for each row
