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!

OracleCommandBuilder.DeriveParameters(OracleCommand command)

User_RBD7WJun 21 2021 — edited Jun 21 2021

Hi Team,
We have one test case try to call a stored procedure on oracle 12c and 19c platforms, it's the exactly the same test case for both platforms. If we run the test separately only on a 12c database, it's fine. If we run the test case only on 19c database, it's also good.
BUT if we get the test case run in a sequence automatically, for example: run test case on 12c first then run the same test case on 19c in one test round: the test case for 12c is OK, but we got exception for the 19c test case.
Exception messge: "System.IndexOutOfRangeException: Index was outside the bounds of the array."
Stack Trace:
OracleCommandBuilder.SetUpDpCommand(OracleCommand command)
OracleCommandBuilder.DeriveParameters(OracleCommand command)

IF we change the running sequence: run test case on 19c first and then 12c in one test round, the 19c test run will be OK, but the 12c test run will failed with this error message: "ORA-01006: bind variable does not exist"
And it's coming from the same point : OracleCommandBuilder.DeriveParameters(OracleCommand command).

So did anyone notice this kind of issue before or any help with this issue? Thanks.

This post has been answered by Alex Keh-Oracle on Apr 20 2023
Jump to Answer
Comments
Post Details
Added on Jun 21 2021
9 comments
1,008 views