初步接触oracle,不知道存储过程怎么改？

[onlygirl2006]

sql server的存储过程要改成oracle的



create procedure spp_freecond_commit(@POPNo varchar(11),@intCount int output)
as
declare @CommitTrainning int

declare @CommitOther int

select @CommitTrainning=sum(UnitReserve*quantity) from TTQ_CommitTrainning where POPNo=@POPNo
select @CommitOther=sum(Reserve) from TTQ_CommitOtherOffer where POPNo=@POPNo

if @CommitTrainning>0 or @CommitOther>0
select @intCount=1
else
select @intCount=0

return @intcount

我现在改成这样，可是报错，大家帮我看看，多谢了

create or replace procedure test_spp_freecond_commit(POPNo in varchar2(11),intCount out number) is
begin

CommitTrainning number;

CommitOther number;



select sum(UnitReserve*quantity) into CommitTrainning from TTQ_CommitTrainning where POPNo=POPNo;
select sum(Reserve) into CommitOther from TTQ_CommitOtherOffer where POPNo=POPNo;

if CommitTrainning>0 or CommitOther>0 then
intCount:=1;
else
intCount:=0;
end if;


end test_spp_freecond_commit;

[onlygirl2006]

谢谢冰啊，很喜欢你这样有耐心，给我改了还告诉我原因

[icedut]

select sum(UnitReserve*quantity) into CommitTrainning from TTQ_CommitTrainning where POPNo=POPNo;
select sum(Reserve) into CommitOther from TTQ_CommitOtherOffer where POPNo=POPNo;

变量名不要和列名相同

create or replace procedure test_spp_freecond_commit(p_POPNo in varchar2,intCount out number) is

输入输出参数不加长度

[icedut]

create or replace procedure test_spp_freecond_commit(p_POPNo in varchar2,intCount out number) is
CommitTrainning number;
CommitOthernumber;
begin

select sum(UnitReserve*quantity) into CommitTrainning from TTQ_CommitTrainning where POPNo=p_POPNo;
select sum(Reserve) into CommitOther from TTQ_CommitOtherOffer where POPNo=p_POPNo;

if CommitTrainning>0 or CommitOther>0 then
intCount:=1;
else
intCount:=0;
end if;

end test_spp_freecond_commit;