sql 在sql develop中执行通过,但在代码中执行出错?请教各位兄弟姐妹
declare V_num number;
begin
select Count(BARCODE) into V_num from DRP_CHECK_DETAIL where SYS_DOC_ID='2' and CHECK_ID= 'C120720002' and BARCODE ='JAACU9IE30I01D06XL1' ;
if V_num >0 then
update DRP_CHECK_DETAIL set REAL_QTY ='1001009' where SYS_DOC_ID ='2' and CHECK_ID='C120720002' and BARCODE ='JAACU9IE30I01D06XL1';
else
insert into DRP_CHECK_DETAIL (SYS_DOC_ID,SYS_DETAIL_ID,CHECK_ID,BARCODE,WAREHOUSE_CODE,ORG_QTY,REAL_QTY,
TRIGGER_TYPE,RETAIL_PRICE,ACCOUNT_PRICE,LAST_UPDATE_DATE,LAST_UPDATE_USER)
values('2',SYS_DETAIL_ID.NEXTVAL,'C120720002','JAACU9IE30I01D06XL1','1001009','0','1','00','580','580',sysdate,'002');
end if ;
end;