How can I debug a parameterized query?

As "Elmar Boye" suggested you should convert the sParam3 to datetime. Probably you should write your code as below

DateTime dt;
if (DateTime.TryParse(sParam3, out dt) == true)
{
    cmd.Parameters.Add("sParam3", OracleDbType.Date).Value = dt;
}
else
{
    cmd.Parameters.Add("sParam3", OracleDbType.Date).Value = DBNull.Value;
}

---

Gaurav Khanna | Microsoft VB.NET MVP | Microsoft Community Contributor