我想创建一个游标,就是传入用户名与密码,然后返回ID,请问下面这一句哪里错了,它老是提示:ORA-00900: 无效 SQL 语句 cursor or replace cur_login(usname varchar2,uspass varchar2) IS
select u_id from login where u_name=usname and u_pass=uspass; 万分感谢..!!!
select u_id from login where u_name=usname and u_pass=uspass; 万分感谢..!!!
cursor cur_login(usname varchar2,uspass varchar2) IS
select u_id from login where u_name=usname and u_pass=uspass;
BEGIN
NULL;
END;
/
cursor cur_login(usname varchar2,uspass varchar2) IS
select u_id from login where u_name=usname and u_pass=uspass;
TYPE cur_login IS REF CURSOR;
ID login.u_id%TYPE
BEGIN OPEN cur_login FOR
'SELECT u_id FROM login WHERE u_name=' || usname ||' and u_pass=' || uspass);
LOOP
FETCH cur_login INTO ID;
EXIT WHEN cur_login%NOTFOUND;
.......
END LOOP;
CLOSE cur_login;
END;
/