declare i number; begin insert into bchkmachine (bcmseqno,bcmrowno,bcmtype,bcmdjbh,bcmfsdate,bcmdate1,bcmmfid, bcmperson1,bcmflag,bcmgdid,bcmbarcode,bcmsl1) values(1,1,'1','kl',to_date(sysdate),to_date(sysdate),'vb','cv','N','fg','kl',23); end;
还是不行 报ora-06550错误 pls-00103:出现符号“;”在需要下列之一时: :=.(@%;notnullrangdefault character 符号";在":"继续之前已插入
declare i number; begin insert into bchkmachine (bcmseqno,bcmrowno,bcmtype,bcmdjbh,bcmfsdate,bcmdate1,bcmmfid, bcmperson1,bcmflag,bcmgdid,bcmbarcode,bcmsl1) values(1,1,'1','kl',to_date(sysdate),to_date(sysdate),'vb','cv','N','fg','kl',23); end; 在试下
i number;
begin
insert into bchkmachine (bcmseqno,bcmrowno,bcmtype,bcmdjbh,bcmfsdate,bcmdate1,bcmmfid,
bcmperson1,bcmflag,bcmgdid,bcmbarcode,bcmsl1)
values(1,1,'1','kl',to_date(sysdate),to_date(sysdate),'vb','cv','N','fg','kl',23);
end;
报ora-06550错误
pls-00103:出现符号“;”在需要下列之一时:
:=.(@%;notnullrangdefault
character
符号";在":"继续之前已插入
i number;
begin
insert into bchkmachine (bcmseqno,bcmrowno,bcmtype,bcmdjbh,bcmfsdate,bcmdate1,bcmmfid,
bcmperson1,bcmflag,bcmgdid,bcmbarcode,bcmsl1)
values(1,1,'1','kl',to_date(sysdate),to_date(sysdate),'vb','cv','N','fg','kl',23);
end;
在试下
快给我说成功否?