新人在此 SELECT 语句中缺少 INTO 子句

CREATE OR REPLACE PROCEDURE PROADMININFO
(ADMINNAME in varchar2,ADMINPWD in varchar2)
IS
BEGIN
select * from userinfo where loginid=ADMINNAME and password=ADMINPWD;
END PROADMININFO;



PROCEDURE ZXDRB.PROADMININFO 编译错误

错误：PLS-00428: 在此 SELECT 语句中缺少 INTO 子句
行：5
文本：select * from userinfo where loginid=ADMINNAME and password=ADMINPWD;

要么使用游标，要么有几个字段定义几个变量如：SQL code

CREATE OR REPLACE PROCEDURE PROADMININFO(ADMINNAME in varchar2,
                                         
                                         ADMINPWD in varchar2) IS
cur_restdata  tbl_rest_waiting_queue%rowtype;--定义游标
   begin
   select *
    into cur_restdata
  from userinfo where loginid=ADMINNAME and password=ADMINPWD;
    end;
END PROADMININFO;

CREATE OR REPLACE PROCEDURE PROADMININFO(ADMINNAME in varchar2,
  ADMINPWD in varchar2) IS
  v_v1 nvarchar2(40);
  v_v2 nvarchar2(40);
BEGIN
  select 字段1，字段2 into v_v1,v_v2
  from userinfo
  where loginid = ADMINNAME
  and password = ADMINPWD;
  end;
END PROADMININFO;
SQL code