Question

执行oracle存储过程，总是出现Warning: Procedure created with compilation errors错误，求高手指点

存储过程create or replace procedure sp_prod1(spbookid in number,spbookname in varchar,sppublishhouse in varchar) is
begin
insert into book values(spbookid,spbookname,sppublishhouse)
end sp_prod1;

执行之后出现Warning: Procedure created with compilation errors错误；

执行show error；

出现错误提示：

PL/SQL: ORA-00933: SQL 命令未正确结束
PL/SQL: SQL Statement ignored
PLS-00103: 出现符号 "end-of-file"在需要下列之一时： ( begin case declare end exception exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge

求大神指点啊

Answer 1

insert下面应该有个commit;（分号也带着）而且你的insert语句后面也没有分号，所以显示命令未结束

Answer 2

结尾是不是少了end？