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

baafce24-48ce-4838-ba19-89682bb7c099

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!

Alex Keh-Oracle

The first place I would look is how are the two DBs configured differently. Could the 11g DB not be using parallelism?

You can add a hint to execute the SQL serially (i.e. /*+ no_parallel(table name) */ ) if you suspect parallelism is the problem.