0

Hi,

Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes:

I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour.

Here is an example, if I have a table in Oracle with 3 rows (or records) in it and run the following query in my code SELECT * FROM MYTABLE it will return only two rows! If I run the same query through TOAD I get all 3 rows.

Does anyone out there know why this is the case?

4
Contributors
3
Replies
11
Views
3 Years
Discussion Span
Last Post by Cesc_1
0

You're either looping through the results incorrectly or you're connecting to a different schema where there's a different number of rows to be returned.

Any other possible options are so remote they're not worth considering.

0

... or you haven't commit the last insert; it usually happens when debugging even to experimented programmers!!!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.