ORA-01422: 实际返回的行数超出请求的行数
2017-08-04 本文已影响0人
Clannad_汐
- 报错的代码
错误原因:因为我的参数sno 和搜索的字段名SNO 一样 (不能一样)
CREATE OR REPLACE
PROCEDURE "serchS" (sno IN VARCHAR2)
AS
v_name varchar2(20);
v_age varchar2(20);
BEGIN
SELECT SNAME INTO v_name FROM S WHERE SNO = sno;
DBMS_OUTPUT.PUT_LINE(v_name);
END;
- 改正后的代码
CREATE OR REPLACE
PROCEDURE "serchS" (sno2 IN VARCHAR2) //改变了变量名
AS
v_name varchar2(20);
v_age varchar2(20);
BEGIN
SELECT SNAME INTO v_name FROM S WHERE SNO = sno2; //改变了变量名
DBMS_OUTPUT.PUT_LINE(v_name);
END;