Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Being there is a missing data using Oracle.ManagedDataAccess.Client

EasonLiuAug 18 2016 — edited Sep 28 2016

Hi everyone

When I test the latest version of the ODP components(Oracle.ManagedDataAccess.Dll Version:4.121.2.20160624) and found a problem,The presence of missing data query results.

Step1.In the database to create table "Test1",“Test2”(Just to verify that the problem no practical meaning)

Test1 colInfo

NameType
IDvarchar2(36)
Namevarchar(255)
T2IDvarchar(36)
Agenumber

Test1 RecordInfo

IDName
T2ID
Age
1jacky1
2sofia1
3micky1

Test2 colInfo

NameType
IDvarchar2(36)
Agenumber

Test2 RecordInfo

IDAGE
118

Step2.C# Code

string sql = "select t1.name,t1.age,t2.age from TEST1 t1 ,test2 t2 where t2.id = t1.t2id"; 

OracleConnection dbConn = new OracleConnection(dbConnStr); 

dbConn.Open(); 

DataTable dt = new DataTable(); 

OracleCommand oracleCommand = new OracleCommand(sql, dbConn); 

OracleDataAdapter da = new OracleDataAdapter(oracleCommand); 

da.Fill(dt); //DataTable Missing Data

Correct Results

NameAGEAGE
jacky18
micky18
sofia18

Error Results

NameAGEAGE
jacky18
micky18
sofia

Look forward to your reply,Thanks.

This post has been answered by EasonLiu on Sep 27 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2016
Added on Aug 18 2016
7 comments
956 views