Last post Feb 27, 2012 01:54 AM by BaxterWoofus
Feb 26, 2012 09:32 PM|BaxterWoofus|LINK
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:
Feb 26, 2012 10:44 PM|Prashant Kumar|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.
Feb 27, 2012 01:54 AM|BaxterWoofus|LINK
Works beautifully all I had to do is change :DEPTCODE to ?
Thank you so much.