Question

以下存储过程总是报SELECT 语句中缺少 INTO 子句，如何更正

create procedure p_findUser(v_id number)is
begin
select id,name,pwd,email,tel,birthday,grade from users where id=v_id;
end;

Answer 1

--应该这样改吧
create procedure p_findUser
(@v_id number)
as
select id,name,pwd,email,tel,birthday,grade from users where id= @v_id;;