Skip to Main Content

ODP.NET

Oracle.ManagedDataAccess - System.IndexOutOfRangeException with FillSchema

Tech ROApr 14 2022

Hello,
I have a strange behavior and I would like to know how to solve it. I am on a .NET Core 6 environment under Visual Studio 2022 and I have referenced the Nuget package Oracle.ManagedDataAccess.Core 3.21.50.

Here is how to reproduce it:
- Open a connection to an Oracle database
- Select all contents of a table
- FillSchema to get the table schema in an adapter
- Modify the table by adding a column for example
- FillSchema to update the schema -> IndexOutOfRangeException

I tried the suggestions here: https://community.oracle.com/tech/developers/discussion/4340718/oracle-manageddataaccess-4-121-1-0-system-indexoutofrangeexception
but the issue persists.

Would you know how to solve this problem which seems to be related to the statement cache and is blocking for us?

You will find in attachment a simple application to reproduce the issue.
OracleIssue.zip (1.85 KB)
Best regards.

This post has been answered by Alex Keh-Oracle on Apr 15 2022
Jump to Answer
Comments
Post Details
Added on Apr 14 2022
4 comments
111 views