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

[KingGJQ]

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;

[programmerxiaocai]

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

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;

[阿健来了]

select 后面缺少赋值into给变量

[wayne很忙]

[Quote=引用 1 楼 programmerxiaocai 的回复:]

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

CREATE OR REPLACE PROCEDURE PROADMININFO(ADMINNAME in varchar2,

ADMINPWD in varchar……
[/Quote]

如1楼

[KingGJQ]

[Quote=引用楼主 kinggjq 的回复:]
CREATE OR REPLACE PROCEDURE PROADMININFO
(ADMINNAME in varchar2,ADMINPWD in varchar2)
IS
BEGIN
select * from userinfo where loginid=ADMINNAME and password=ADMINPWD;
END PROADMININFO;



PROCE……
[/Quote]


PROCEDURE ZXDRB.PROADMININFO 编译错误

错误：PLS-00103: 出现符号 "END"
行：8
文本：END PROADMININFO;

[programmerxiaocai]

END PROADMININFO 前面来个end;

[我心飞翔]

在pl/sql程序中不允许出现不带into子句的select语句。
参考代码如下：如果查询出来只有一条记录

CREATE OR REPLACE PROCEDURE PROADMININFO
(adminName in varchar2, adminPWD in varchar2)
IS
    rec userinfo%ROWTYPE;
BEGIN
    SELECT * INTO rec FROM UserInfo WHERE loginid = adminName AND password = adminPWD;
END PROADMININFO;

如果查询出来的记录有多条
那就需要使用光标了。

[huangdh12]

procedure 不能仅仅只执行一个select语句。

[tlc0211]

谢谢各位大神热心的教导。本人刚开始学习oracle

[yinan9]

[Quote=引用 10 楼 tlc0211 的回复:]

谢谢各位大神热心的教导。本人刚开始学习oracle
[/Quote]加油啊!共勉！

[灿烂千阳i]

查出来的数据应该有个容器来装它

[KingGJQ]

[Quote=引用 6 楼 luiseradl 的回复:]
在pl/sql程序中不允许出现不带into子句的select语句。
参考代码如下：如果查询出来只有一条记录


SQL code

CREATE OR REPLACE PROCEDURE PROADMININFO
(adminName in varchar2, adminPWD in varchar2)
IS
rec userinfo%ROWTYPE;
BEGIN
……
[/Quote]

谢谢各位大神热心的教导。本人刚开始学习oracle