Parameterized TableAdapter Error in Visual Studio for ODP.NET

User_M80CR

Hello Team,

Attached ZIP file contains complete Visual Studio Solution Work Area which demonstrates the problem with Parameterized TableAdapter Query Builder error while using ODP.NET driver.

But same feature works perfectly fine witn Microsoft SQL Server.

Can you please help me resolve the issue after you create the sample work area at your end and visualize the problem?

I am using standard SCOTT Schema for testing purpose.

Attached PDF File contains all the necessary steps to recreate the problem.

Let me know if you need any other information.

Best Regards

Bug_Parameterized_Table_Adapater.pdf

Bug_Parameterized_TableAdapter.zip

Christian.Shay -Oracle

This seems to be a bug. It seems to generic to query builder - specifically any parameter in query builder causes it to fail with the "INTERNAL ERROR, INVALID PANE CONFIGURATION" error.

Bug 32705020 has been filed for this issue.

User_M80CR

Hello Christian,

Thank you for confirming that it is a bug in ODP.NET.

I am unable to view the Bug 32705020 in My Oracle Support [MOS]. Is it not public till now?

I found following link which also mentions about similar bug as I observed :

VS 2010 Dataset Designer Oracle Parameters bind by name ODAC 11 R3

https://community.oracle.com/tech/developers/discussion/2174025/vs-2010-dataset-designer-oracle-parameters-bind-by-name-odac-11-r3

Tableadapters giving "Incorrect parameter" error

https://community.oracle.com/tech/developers/discussion/2259395/tableadapters-giving-incorrect-parameter-error

Best Regards

User_M80CR

Two more same error complain before also :

Visual Studio 2015 ODAC with ODT for VS (32bit) Invalid pane configuration

Visual Studio 2015 ODAC with ODT for VS (32bit) Invalid pane configuration — oracle-tech

https://community.oracle.com/tech/developers/discussion/3945190/visual-studio-2015-odac-with-odt-for-vs-32bit-invalid-pane-configuration

Problems with VS.net 2013 DataSet Designer and Oracle 12c

Problems with VS.net 2013 DataSet Designer and Oracle 12c — oracle-tech

https://community.oracle.com/tech/developers/discussion/3879664/problems-with-vs-net-2013-dataset-designer-and-oracle-12c

Christian.Shay -Oracle

I think you are correct that the bug is not public. Yes, it appears this is a very longstanding bug (although it was just filed on your behalf).

User_M80CR

Hello Christian,

Even this perfectly valid SQL Command shows error in ODP.NET based Query Builder GUI.

Please update the Bug Report accordingly as it is not publicly available and confirm in this issue trail with your valuable insight :

SELECT 1 AS NODE_ID, (SELECT 'CHILD' FROM DUAL) AS ECHELON FROM DUAL

Running the same command from SQLPlus is as shown below for reference :

Waiting to hear from you.

Best Regards