ORA-01008: not all variables bound. They are bound

by

I know this is an old question, but it hasn’t been correctly addressed, so I’m answering it for others who may run into this problem.

By default Oracle’s ODP.net binds variables by position, and treats each position as a new variable.

Treating each copy as a different variable and setting it’s value multiple times is a workaround and a pain, as furman87 mentioned, and could lead to bugs, if you are trying to rewrite the query and move things around.

The correct way is to set the BindByName property of OracleCommand to true as below:

var cmd = new OracleCommand(cmdtxt, conn);
cmd.BindByName = true;

You could also create a new class to encapsulate OracleCommand setting the BindByName to true on instantiation, so you don’t have to set the value each time. This is discussed in this post

More Related Contents:

  1. Index was outside the bounds of the array how to resolve
  2. The provider is not compatible with the version of Oracle client
  3. How to bind a List to a ComboBox?
  4. What is the minimum client footprint required to connect C# to an Oracle database?
  5. Data binding dynamic data
  6. Databinding to List – See changes of data source in ListBox, ComboBox
  7. List vs BindingList Advantages/DisAdvantages
  8. databind the Source property of the WebBrowser in WPF
  9. Handling ExecuteScalar() when no results are returned
  10. How to set a binding in Code?
  11. WPF databinding to interface and not actual object – casting possible?
  12. How to force a WPF binding to refresh?
  13. how to bind datatable to datagridview in c#
  14. Binding DataGrid to ObservableCollection
  15. How can I deploy a .NET application that uses ODAC without installing the whole component to the user?
  16. OracleParameter and IN Clause
  17. ComboBox SelectedItem vs SelectedValue
  18. OraOLEDB.Oracle provider is not registered on the local machine
  19. WPF checkbox binding
  20. C#: Oracle Data Type Equivalence with OracleDbType
  21. Is it possible to bind complex type properties to a datagrid?
  22. Can I somehow temporarily disable WPF data binding changes?
  23. WPF TwoWay Binding to a static class Property
  24. Why would Oracle.ManagedDataAccess not work when Oracle.DataAccess does?
  25. PropertyChanged for indexer property
  26. Why does WPF databinding swallow exceptions?
  27. Winforms : How to bind the Checkbox item of a CheckedListBox with databinding
  28. Binding datagrid column width
  29. Binding to custom control inside DataTemplate for ItemsControl
  30. General Observable Dictionary Class for DataBinding/WPF C#

Leave a Comment