存储过程中有一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语句时是有记录的,不知道怎么回事 ?
..................................................
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语句时是有记录的,不知道怎么回事 ?
解决方案 »
- oracle触发器
- oracle 删除表问题
- 怎样用REGEXP_SUBSTR拆分字符串:A_BC_DEF_GHI_JKL_MN
- 下面这个关于merge的sql语句执行好久都没反应,不知道那里错了
- 数据库启动控制触发器全部不执行的参数
- 紧急求助!!关于merge的问题,可以update但不能insert
- ORA-12154: TNS: 无法解析指定的连接标识符
- ORACLE9安装的问题
- oracle中要查询某个时间段(年月日)内的记录,SQL语句怎么写最方便?
- oracle新手求帮忙写一条SQL
- 请问如何将sybase数据库中的表转入到oracle 10g中
- Oracle10g 数据的汇总/分析计算问题。Aggregate, Analytic Function/ Windowing Clause/ User-defined Function
select fieldname into cnt from tbl where conditions..;
exception
when no_data_found then
...
end;