Create function pro_getfid(Sid integer)
retrun integer;
As
id integer;
Begin
Update t_getfid Set Fid=Fstep+1 Where Ftable=Sid;
Select Fid into id From t_getfid Where Ftable=Sid;
return id;
End
retrun integer;
As
id integer;
Begin
Update t_getfid Set Fid=Fstep+1 Where Ftable=Sid;
Select Fid into id From t_getfid Where Ftable=Sid;
return id;
End
As
Begin
Update t_getfid Set Fid=Fstep+1 Where Ftable=Sid;
Select Fid into Sid From t_getfid Where Ftable=Sid;
End
As
Begin
Update t_getfid Set Fid=Fstep+1 Where Ftable=Sid;
begin
Select Fid into Sid From t_getfid Where Ftable=Sid;
exception
when others then
Sid := 0;--没有记录或记录数大于1时
end;
End
retrun integer;
As
id integer;
Begin
Update t_getfid Set Fid=Fstep+1 Where Ftable=Sid;
Select Fid into id From t_getfid Where Ftable=Sid;
return id;
End;把错误贴出来!!!
行号= 2 列号= 1 错误文本= PLS-00103: 出现符号 "RETURN"在需要下列之一时: ; is with authid as cluster order using external deterministic parallel_enable用zw_yu(鱼猫)
行号= 1 列号= 40 错误文本= PLS-00103: 出现符号 "OUT"在需要下列之一时: := . ) , @ % default character 符号 "," 被替换
Create function pro_getfid(Sid integer)
retrun integer --这里不能有分号
As
id integer;
Begin
Update t_getfid Set Fid=Fstep+1 Where Ftable=Sid;
Select Fid into id From t_getfid Where Ftable=Sid;
return id;
End;