Hi, Can anyone tell me why this code (last line) gives the error:
ORA-01008: not all variables bound

Dim OracleCommand As OracleCommand = New OracleCommand("select * from txfldlog where txid=:pTxID", oSource)
OracleCommand.Parameters.Add(New OracleParameter("pTxID", OracleType.Number, 20, "txid")).Direction = ParameterDirection.Input
Dim OracleDataReader As OracleDataReader = OracleCommand.ExecuteReader()

As far as I can see I am doing it correctly. Alternatively anyone have some code showing how to return a parameterized query into a datareader obj.

Thanks
Tim