存储过程的注释不能写在第一行

select后面要有into

create or replace procedure DelEmp(v_empno in emp.empno%type) ASNo_result EXCEPTION;salary varchar2(40);--nod 18-10-14begindelete from emp where empno=v_empno; select sum(sal) into salary from emp group by ename;if sql%NOTFOUND THEN RAISE No_result; end if; DBMS_OUTPUT.PUT_LINE(‘编码为‘||v_empno||‘已删除！！！‘); COMMIT;exception when No_result then DBMS_OUTPUT.PUT_LINE(‘你要的数据不存在，请确认是否为‘||v_empno); WHEN others then DBMS_OUTPUT.PUT_LINE(‘其他错误，请确认输入‘);END DelEmp;