type t_type_rt is table of emp_lyh%rowtype;
function f_return_table(p_salary varchar2) return t_type_rt
pipelined is
begin
for c_get in (select * from emp_lyh t where t.salary >= p_salary) loop
pipe row(c_get);
end loop;
return;
exception
when others then
return null;
end f_return_table;
-- return null;这里报错,Error: PLS-00103: Encountered the symbol "RETURN" when expecting one of the following: then or The symbol "then was inserted before "RETURN" to continue.
改为null当然就正确了,但我想返回空值,应该怎么写
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货