大家帮忙看下 我这段PL\SQL那错了

tan1301230147

CREATE OR REPLACE PROCEDURE selectemp(employeeno IN INTEGER)
IS
  employeename vachar2(20);
  employeejob varchar2(9);
  employeehiredate date;
  employeesal number(7,2);

BEGIN
  select    ename, job, hiredate, sal
  into         employeename, employeejob, employeehiredate, employeesal
  from         emp
  where   empno = employeeno
DBHS_OUTPUT.put_line('员工姓名'
                ||employeename
                ||'员工岗位'
                ||employeejob
                ||'雇佣日期'
                ||employeehiredate
                ||'薪水'
                ||employeesal);
EXCEPTION
  when others
        then
        DBHS_OUTPUT.put_line('ERRORS!!!');
end;
/

jackson198574

报错了嘛？

li0924

看

1. select    ename, job, hiredate, sal
   
2.   into         employeename, employeejob, employeehiredate, employeesal
   
3.   from         emp
   
4.   where   empno = employeeno;

复制代码

少了一份分号

dingning239

楼上正解，这个select赋值语句最后少了分号

吹风筒

呵呵呵呵呵呵呵呵呵和呵呵呵

renxiao2003

太仔细了。少个分号就看出来了。其实楼主只要在ORACLE环境下运行一下也很快有提示的。

tan1301230147

回复 3# li0924

thank you