- 3,734,267 Users
- 2,246,934 Discussions
- 7,857,216 Comments
Forum Stats
Discussions
Howdy, Stranger!
Categories
- 380.9K All Categories
- 2.1K Data
- 203 Big Data Appliance
- 1.9K Data Science
- 446.1K Databases
- 220.4K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 506 MySQL Community Space
- 459 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 438 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.4K SQL & PL/SQL
- 20.8K SQL Developer
- 291.3K Development
- 6 Developer Projects
- 117 Programming Languages
- 288.1K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.2K Java
- 18 Java Learning Subscription
- 36.9K Database Connectivity
- 149 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.7K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 12 Java Essentials
- 138 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 195 Java User Groups
- 22 JavaScript - Nashorn
- Programs
- 180 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 165 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
Parameterized TableAdapter Error in Visual Studio for ODP.NET
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
Answers
-
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.
-
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
Tableadapters giving "Incorrect parameter" error
Best Regards
-
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
Problems with VS.net 2013 DataSet Designer and Oracle 12c
Problems with VS.net 2013 DataSet Designer and Oracle 12c — oracle-tech
-
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).
-
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