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

    Forum Stats

  • 3,716,000 Users
  • 2,242,928 Discussions
  • 7,845,734 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

baafce24-48ce-4838-ba19-89682bb7c099
edited January 2020 in ODP.NET

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!

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,753 Employee
    edited January 2020

    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.

Sign In or Register to comment.