Oracle

If you ever use the Oracle ODP.Net component with SqlDataSource and get the ORA-01036 Illegal variable name/number error, it is mainly due to the fact that your number of parameters does not match the number in your Insert, Update, or Delete query. I had this problem using a ComposedKey with the ASPxDataGridView from DevExpress. You need to remove the ComposedKey field before executing the query.

Here is the conversation on ASP.Net that helped me resolve this issue.

If you want to use Oracle’s ODP.Net 9 and 11 in parallel, you must absolutely uninstall version 9 of Oracle.DataAccess from the GAC. It was blocking me when I wanted to use the graphical tools of VS2008 (Server Explorer and DevExpress).

My question on StackOverflow