This content has been marked as final. Show 2 replies
Your Parameters.Add line does not look right at all. You are using SQL syntax (TO_DATE) where you should not be.
This is the Visual Studio Tools forum, for best results, please repost this over on the ODP.NET forum:
It's kind of early in the morning to remember the exact syntax, but IIRC it's going to look more like this:
Dim dt as DateTime = DateTime.Parse("2011/07/18")
cmd.Parameters.Add(":DOB", OracleDbType.Date, value)
The thing is that you want to pass the parameter as a Date object, not as a String.