How can I debug a parameterized query?

Hi,

just some guessing, as there is no SQL and schema information.

You declare sParam3 as Date type but assigning a string:

 cmd.Parameters.Add("sParam3", OracleDbType.Date).Value = sParam3;

You should convert the sParam3 to a Datetime or use a varchar2 parameter and a Oracle function like TO_DATE to convert it in the query.

For better breakpoint handling: Move the declaration of OracleCommand cmd outside the try catch block, then you can set a breakpoint in the catch block and the CommandText property and its Parameters collection is accessible.

Regards, Elmar