自己创建的用户a
已经分配了create session 和 create table 权限,登陆后写如下代码::
create or replace procedure sp_userlogin(xino_UID in varchar2, xino_PWD in varchar2,xion_UT in
varchar2,count out number)
as
begin
Select count(*) into count from UserTable where User_Code=xino_UID and User_Pwd=xino_PWD and Us
exception when no_data_found
count:=-1;
end;
/
create or replace procedure sp_userlogin(xino_UID in varchar2, xino_PWD in varchar2,xion_UT in
*
ERROR 位于第 1 行:
ORA-01031: 权限不足
如何解决???在线等待 多谢!!~~~~~~