SELECT NVL(fAvalibleNum,0),NVL(fRealNumMain,0),NVL(fCost,0),
NVL(fBorrowNum,0),NVL(fLendNum,0),NVL(fMakingNum,0),NVL(fUnSendNum,0),
NVL(fOnWayNum,0),NVL(fOrderNum,0)
into v_fAvalibleNum,v_fRealNumMain,v_fCost ,v_fBorrowNum,v_fLendNum,
v_fMakingNum ,v_fUnSendNum,v_fOnWayNum ,v_fOrderNum
FROM TB_INV_GOODS
WHERE vcAspID = v_vcAspID AND vcStoreCode = v_storeCode
AND vcGoodsID = v_goodsID;
oracle存储过程中执行这条语句时提示 ORA-01403未找到数据
请问是什么错误?
NVL(fBorrowNum,0),NVL(fLendNum,0),NVL(fMakingNum,0),NVL(fUnSendNum,0),
NVL(fOnWayNum,0),NVL(fOrderNum,0)
into v_fAvalibleNum,v_fRealNumMain,v_fCost ,v_fBorrowNum,v_fLendNum,
v_fMakingNum ,v_fUnSendNum,v_fOnWayNum ,v_fOrderNum
FROM TB_INV_GOODS
WHERE vcAspID = v_vcAspID AND vcStoreCode = v_storeCode
AND vcGoodsID = v_goodsID;
oracle存储过程中执行这条语句时提示 ORA-01403未找到数据
请问是什么错误?
我在PL/SQL中测试该存储过程时,执行到上面那条语句时,就会报 'ORA-01403未找到数据',但是我把这条语句单独拿到SQL窗口去执行时,是可以执行的并且能查到记录,不知道怎么回事?
NVL(fBorrowNum,0),NVL(fLendNum,0),NVL(fMakingNum,0),NVL(fUnSendNum,0),
NVL(fOnWayNum,0),NVL(fOrderNum,0)
没有取到 数据