求牛人帮我看看是什么情况
先上sql
declare
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是否重复然后再插入
但是操作的时候会报错
求牛人帮我看看什么问题