create or replace procedure apps.proc_select
(
s_sid in number,
s_sid2 in number,
s_sname out text.sname%type,
s_school out text.school%type
)
is
begin
for v_cur in (select sname,school into s_sname,s_school from text where sid >=s_sid and sid <= s_sid2) loop
dbms_output.put_line('s_sname:'||v_cur.sname||'s_school:'||v_cur.school);
end loop;
exception
when no_data_found then
dbms_output.put_line('该部门编号不存在');
end proc_select;
---这个是存储过程