存储过程中有一select语句如下:
..................................................
SELECT a.goodsID,b.vcGoodsCode,a.goodsName,a.goodsSize,b.vcStoreCode,nvl  
            (a.unitMath,0),nvl(b.fManuNum,0),nvl(b.fMakeCost,0),
                       nvl(a.minNum,0),nvl(a.maxNum,0),nvl(a.safeNum,0) 
   into v_goodsID,v_goodsCode,v_goodsName,v_goodsSize,v_storecode,
               v_unitMath,v_fManuNum,v_fMakeCost,
                     v_minNum,v_maxNum,v_safeNum  
    FROM TB_BASE_GOODS a,TB_MANU_ASSEMBLE b 
       WHERE b.vcBillID =v_vcBillID  AND b.vcAspID = v_vcAspID  
              AND a.vcAspID = b.vcAspID 
              AND a.goodsCode = b.vcGoodsCode  ;    
...........................
在pl/sql的测试窗口中进行测试时,提示'ORA-01403:未找到数据 ',但我在pl/sql的sql窗口中执行这条select语句时是有记录的,不知道怎么回事 ?