Question

oracle存储过程出错，哪位大侠帮我看看

SQL> create or replace procedure proc_del
2 ( emp_id in number(8))
3 is
4 begin
5 delete from employee where id=emp_id;
6 commit;
7 end;
8 /

警告: 创建的过程带有编译错误。
PROCEDURE PROC_DEL 出现错误:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/4 PLS-00103: 出现符号 "end-of-file"在需要下列之一时：
( begin case
declare end exception exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge

Answer 1

2 ( emp_id in number(8)) 改成
( emp_id in number)

3 is
改成 as

追问

SQL> create or replace procedure proc_del
2 ( emp_id in number)
3 as
4 begin
5 delete from emploayee where id=emp_id;
6 commit;
7 emd;
8 /

警告: 创建的过程带有编译错误。

追答

show error 看看错误啊

delete from emploayee where id=emp_id;
是不是表名写错了？ employee?