请教一个oracle存储过程的问题 - Oracle / 基础和管理

代码如下：
create procedure putdraw
(ID char,money number)
as
vbalance number,vname char;
begin
select Bmoney,name into vbalance,vname from bankcheck
where CIN=ID;
if(vname is null) then
raise_application_error(-20000,'please create a zhanghao');
end if;
update bankcheck set Bmoney=Bmoney+money
where CIN=ID;
end;
/

要实现对bankcheck存钱，如果没有账户就需要重新开新账户，上面出错不知怎么处理，望各位高手指点下

---

没人，自己顶顶先

---

if 你加括号了。

---

vname char;
改成VARCHAR2(5)

---

建议用merge
merge into tablea
using tableb
on (conditions)
when matched then
  update
  set ...
when not matched then
insert into
values (...)

---

关键错误在于你定义的两个变量之间不能用逗号分隔。
SQL code:
SQL> create procedure putdraw
2 (ID char,money number)
3 as
4 vbalance number;
5 vname char;
6 begin
7 select Bmoney,name into vbalance,vname from bankcheck
8 where CIN=ID;
9 if(vname is null) then
10 raise_application_error(-20000,'please create a zhanghao');
11 end if;
12 update bankcheck set Bmoney=Bmoney+money
13 where CIN=ID;
14 end;
15 /

Procedure created
SQL> select * from bankcheck;

BMONEY NAME CIN
---------- -----