Environment:
Visual Studio 2010, Windows Forms Application, Oracle Database
I am trying to use a parameter in a DataSet.xsd DataTable.
The query and parameter work fine in Query Builder but gives an error if I try "Preview Data" or use in my application.
Error: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
Additional information: ORA-01008: not all variables bound
BaxterWoofus
Member
9 Points
8 Posts
Using a parameter in a DataTable - ORA-01008: not all variables bound
Feb 26, 2012 09:32 PM|LINK
Environment:
Visual Studio 2010, Windows Forms Application, Oracle Database
I am trying to use a parameter in a DataSet.xsd DataTable.
The query and parameter work fine in Query Builder but gives an error if I try "Preview Data" or use in my application.
Error: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
Additional information: ORA-01008: not all variables bound
For full details on the application setup / my troubleshooting so far see here:
http://www.fullstackbusinessdesign.com/forums/ORA-01008.html
tableadapter dataset query DataTable oracle
Prashant Kum...
Star
12344 Points
1992 Posts
Re: Using a parameter in a DataTable - ORA-01008: not all variables bound
Feb 26, 2012 10:44 PM|LINK
It seems you are using OleDb provider for Oracle. The bind variable should be a question mark "?".
The bind variable :DEPTCODE would be valid for System.Data.OracleClient.
BaxterWoofus
Member
9 Points
8 Posts
Re: Using a parameter in a DataTable - ORA-01008: not all variables bound
Feb 27, 2012 01:54 AM|LINK
Works beautifully all I had to do is change :DEPTCODE to ?
Thank you so much.