是将以下的这个改到oracle中啊,哪位大侠帮改下啊! creat procedure M_keyword_delete icode varchar(8) as if icode <>'' delete from t_keyword where entrycode = icode if @@error =0 select "success" as resultinfo else select 'failure' as resultinfo
creat procedure M_keyword_delete icode varchar(8) as begin if icode <>'' then delete from t_keyword where entrycode = icode; end if; select "success" as resultinfo;exception when others then select 'failure' as resultinfo; end 是不是这样
... Exception when SQLCODE = 0 then ....;...SQLCODE 为关键字.
你能把那一句完整的定吗?我刚学oracle很菜的啊
creat procedure M_keyword_delete
icode varchar(8)
as
if icode <>''
delete from t_keyword where entrycode = icode
if @@error =0
select "success" as resultinfo
else
select 'failure' as resultinfo
icode varchar(8)
as
begin
if icode <>'' then
delete from t_keyword where entrycode = icode;
end if;
select "success" as resultinfo;exception when others
then
select 'failure' as resultinfo;
end
是不是这样
Exception
when SQLCODE = 0 then
....;...SQLCODE 为关键字.