先上sqldeclare
v_count number;
begin
select count(*) into v_count from planeuser.f_device x where x.nscomid=:nscomid_;
if(v_count>0) then
:RETURNSTR_ :='重复IP';
else
Insert into PlaneUser.F_DEVICE
( AREAID,DEVICEID,DEVICETYPE,GATE,NSCOMID,NSDEVICENAME,PRODUCE,RESOLUTION,SCREENTYPEID,TYPENO,delflag,updatedatetime )
values
( :AREAID_,:DEVICEID_,:DEVICETYPE_,:GATE_,:NSCOMID_,:NSDEVICENAME_,:PRODUCE_,:RESOLUTION_,:SCREENTYPEID_,:TYPENO_,0,sysdate );
end if;
end;此语句是为了判断输入的IP是否重复然后再插入但是操作的时候会报错求牛人帮我看看什么问题
v_count number;
begin
select count(*) into v_count from planeuser.f_device x where x.nscomid=:nscomid_;
if(v_count>0) then
:RETURNSTR_ :='重复IP';
else
Insert into PlaneUser.F_DEVICE
( AREAID,DEVICEID,DEVICETYPE,GATE,NSCOMID,NSDEVICENAME,PRODUCE,RESOLUTION,SCREENTYPEID,TYPENO,delflag,updatedatetime )
values
( :AREAID_,:DEVICEID_,:DEVICETYPE_,:GATE_,:NSCOMID_,:NSDEVICENAME_,:PRODUCE_,:RESOLUTION_,:SCREENTYPEID_,:TYPENO_,0,sysdate );
end if;
end;此语句是为了判断输入的IP是否重复然后再插入但是操作的时候会报错求牛人帮我看看什么问题
LZ的意思是不是把这个变量赋值为重复IP,类似RETURNSTR_ :='重复IP';