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!

ODP.Net-"ORA-01002: fetch out of sequence"

baafce24-48ce-4838-ba19-89682bb7c099Jan 9 2020 — edited Jan 9 2020

We are migrating our applcation code to use ODP.Net from ADO.Net provider for better support of recent releases of Oracle.

I am using ODP.Net 19c. This works fine when connected to a 11g database. However, when i test with 12c or 19c databases, i get this error in my .Net code - "ORA-01002: fetch out of sequence"

I found that the executions are happening parallelly which might be causing the issues.Any ideas about this?

Why would the same code work fine with a 11g db and not for 12c or 19c databases?

Can we force sequential execution somehow in the .Net code?

.Net Framework 4.5 , ASP.Net application.

Oracle DB server - 12C or 19C 64-bit

Oracle Client - 19C 32-bit

ODP.Net- 19C (Managed Driver)

While testing for 11g database-

Oracle DB server - 11 64-bit

Oracle Client - 11g 32-bit

ODP.Net- 19C (Managed Driver)

Appreciate any help here.

Thanks!

Comments

Post Details

Added on Jan 9 2020
1 comment
697 views