存储过程中有一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 删除表时表名一直存在。
- 重新配置ORCL11g的EM时遇到问题
- 数据库事务
- oracle 锁表原因
- Oracle表达式求值,有这样的内置包可用吗?
- 100分求解 ,在线等待
- 如何对统计项进行排序
- 关于to_char()函数的一个很奇怪的现象
- 急!!!!!!!!!!!我的OracleTNSListener80服务无法启动??
- 请问如何将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;