SQl:
select C00D as LH, C00H as DYH, C00E as FJH, C003 as YZXM
, C001 as GFK, C00F as FWMJ, C002 as JCBL, FWZJ_JFDMX.YJJE
, FWZJ_JFDMX.JFDBH
from FWZJ_JFDMX, FWZJ_JFD
where FWZJ_JFDMX.JFDBH = FWZJ_JFD.JFDBH and XBJSQBH = is_JFSQBH and JKLX = '2'
order by C00D, C00H, C00E; 使用pl/SQL测试 传入is_JFSQBH 查询数据数为218
使用DATaAdapter fill填充DataSet 显示7199
DataSet记录数不稳定 有时候218 有时7199 没有规律Oracle 基本信息
Using
Home: OraHome92
DLL: E:\oracle\ora92\bin\oci.dll
OCI: Version 9.0
Oracle9i Enterprise Edition Release 9.2.0.1.0
Character size: 2 byte(s)
.net 1.1
可能
原因Oracle 库问题 Or .net 问题
select C00D as LH, C00H as DYH, C00E as FJH, C003 as YZXM
, C001 as GFK, C00F as FWMJ, C002 as JCBL, FWZJ_JFDMX.YJJE
, FWZJ_JFDMX.JFDBH
from FWZJ_JFDMX, FWZJ_JFD
where FWZJ_JFDMX.JFDBH = FWZJ_JFD.JFDBH and XBJSQBH = is_JFSQBH and JKLX = '2'
order by C00D, C00H, C00E; 使用pl/SQL测试 传入is_JFSQBH 查询数据数为218
使用DATaAdapter fill填充DataSet 显示7199
DataSet记录数不稳定 有时候218 有时7199 没有规律Oracle 基本信息
Using
Home: OraHome92
DLL: E:\oracle\ora92\bin\oci.dll
OCI: Version 9.0
Oracle9i Enterprise Edition Release 9.2.0.1.0
Character size: 2 byte(s)
.net 1.1
可能
原因Oracle 库问题 Or .net 问题
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货