sno sname pno
1   test  1
2   test2 2
3   test3 3
create or replace procedure stu_proc1(pno in student.sno%type) as
pname varchar2(25);
begin
select sname into pname from student where sno=pno;
dbms_output.put_line(pname);
end;

call stu_proc1(2);

Error Id: ORA-01422

Title: exact fetch returns more than requested number of rows

Description:

exact fetch returns more than requested number of rows

Action:

Rewrite the query or change number of rows requested

Cause:

The number specified in exact fetch is less than the rows returned.

-- 来自：