oracle 执行结果报警“实际返回的行数超出请求的行数”

create or replace function yyh_get_info(name VARCHAR2,title OUT VARCHAR2)
return varchar2
AS
depno yyh_test.depno%TYPE;
BEGIN
 SELECT a.job,a.depno into title, depno from yyh_test  a where upper(a.name)=upper(name) and rownum=1 ；

 RETURN depno;
 EXCEPTION
 WHEN NO_DATA_FOUND THEN
 raise_application_error(-20000,'该雇员不存在');
END;

 

加上蓝色字体rownum=1 解决这个报警