procedure check_pass(v_operid varchar2,v_pass varchar2,out_ifpower out varchar2)
is
n_count integer;
str_pass varchar2(50);
begin
select count(*) into n_count from operate where operid=v_operid;
if n_count=0 then
out_ifpower:='0';
else
select pass into str_pass from operate where operid=v_operid;
if str_pass=v_pass then
--out_ifpower:=1;
select roleid into out_ifpower from operate where operid=v_operid;
else
out_ifpower:='0';
end if;
end if;
end;
is
n_count integer;
str_pass varchar2(50);
begin
select count(*) into n_count from operate where operid=v_operid;
if n_count=0 then
out_ifpower:='0';
else
select pass into str_pass from operate where operid=v_operid;
if str_pass=v_pass then
--out_ifpower:=1;
select roleid into out_ifpower from operate where operid=v_operid;
else
out_ifpower:='0';
end if;
end if;
end;
解决方案 »
- oracle 用什么命令可以查看锁定的表,并杀死这个进程
- oracle job创建出错
- orcale中 表名是变量
- Oracle中的触发器与存储过程在每次服务器重启后都变动红色无效状态,必须在触发器与存储过程上进行编译才能变成正常有效状态。请问各位如
- 怎样倒入文本文件?
- 菜鸟高分求一存储过程
- 进SQL*PLUS时,提示错误:ORA-01033: ORACLE initialization or shutdown in progress
- sql 语句,关于时间条件的判断请教。
- 请教请教急急呀
- 如何计算结存数地问题?
- 我在用oracle时有一个这样的问题:请大家帮我看看
- 问2个简单的小问题(60)
2、“out_ifpower” 的传入参数设定长度了吗?
procedure check_pass(v_operid varchar2,v_pass varchar2,out_ifpower out varchar2) is
begin
select roleid into out_ifpower from operate where operid=v_operid and pass=v_pass;
exception
when no_data_found then
out_ifpower := '0';
end;