create or replace package employee_pkg as procedure print_ename(p_empno number) is l_ename scott.emp.ename%type; begin select ename into l_ename from scott.emp where empno=p_empno; dbms_output.put_line(l_ename); exception when NO_DATA_FOUND then dbms_output.put_line('Invalid employee number.'); end print_ename; end employee_pkg; /
as procedure print_ename(p_empno number)
is
l_ename scott.emp.ename%type;
begin
select ename
into l_ename
from scott.emp
where empno=p_empno;
dbms_output.put_line(l_ename);
exception
when NO_DATA_FOUND then
dbms_output.put_line('Invalid employee number.');
end print_ename;
end employee_pkg;
/
然后自己解决
-------- -----------------------------------------------
4/13 PLS-00201: 必须说明标识符 'SCOTT.EMP'
4/13 PL/SQL: Item ignored
6/5 PL/SQL: SQL Statement ignored
8/16 PL/SQL: ORA-00942: 表或视图不存在
10/5 PL/SQL: Statement ignored
10/26 PLS-00320: 此表达式的类型说明不完整或格式不正确