提示编译错误

Question

先创建表
create table student(xuehao char(10), 
                     xingming char(10),
                     nianling number(2,0),
                     zhuanye  avrchar(16),
                     xibie    varchar(16),
                     primary key(xuehao));
创建存储过程
create or replace   procedure stu_pro
(xuehao in char(10),xingming in char(10),nianling in number(2,0),zhuanye in varchar(16),
xibie varchar(10))
as
begin
insert into student values(xuehao,xingming,nianling,zhuanye,xibie)
end stu_pro;
怎么创建的存储过程提示编译错误,谁能帮我说明和指出程序中的错误,万分感激!

Answer 1

create or replace   procedure stu_pro
(xuehao in char,xingming in char,nianling in number,zhuanye in varchar,
xibie varchar)
as
begin
insert into student values(xuehao,xingming,nianling,zhuanye,xibie)
end stu_pro;