Workaround for the ORA-01008 error when working with .net datasets

When you try to use the original provider dll from Oracle (Oracle.DataAccess.dll ) instead of the one of Microsoft's ( System.Data.OracleClient.dll ) there is a possibility that you will get an annoying error like

ORA-01008: not all variables bound

This is due because the Oracle guys decided to bind the parameters when executing a SQL command by index as default behavior instead of bind them by name. You will get this error when you use more than one parameter.

Read full article