create or replace procedure Insert_Ro
(
uname varchar2,
qqnum varchar2,
flag out number
)
as
tempname temp1.username%type;
begin
select username into tempname from temp1 where username=uname;
flag:=0;
exception
when NO_DATA_FOUND then
begin
insert into temp1(pkid,username,qq) values(aaa.nextval,uname,qqnum);
select aaa.currval into flag from dual;
end;
when others then
raise;
end Insert_Ro;
---另外,这个存储过程没有commit可以提交到数据库中吗
(
uname varchar2,
qqnum varchar2,
flag out number
)
as
tempname temp1.username%type;
begin
select username into tempname from temp1 where username=uname;
flag:=0;
exception
when NO_DATA_FOUND then
begin
insert into temp1(pkid,username,qq) values(aaa.nextval,uname,qqnum);
select aaa.currval into flag from dual;
end;
when others then
raise;
end Insert_Ro;
---另外,这个存储过程没有commit可以提交到数据库中吗
raise是当出现异常的时候,进行的处理
这里不能提交到数据库中,可以在主调程序提交。