How to get a c# DateTime accepted into an Oracle stored procedure

[cthomas7k]

This issue has been driving me crazy. Here is my code snippet: Also see attachement
The variable:var pid = DateTime.ParseExact(e.RowData["PLAN_ISSUE_DATE"], "dd-MMM-yyyy", null);
The stored procedure parameter:cmd.Parameters.Add("P_DOC_ISSUE_DATE", OracleDbType.Date).Value = pid;
The error:PLS-00306: wrong number or types of arguments in call to

I have been surfing for 3 days trying to resolve this issue, please help! Thanks!

[cthomas7k]

Solution: Make sure you dba tells you that he has set a window on the date parameter so you know when you enter a value outside of that window it retuns a null value, therby making you code fail, Yikes! Communication is key.
For all others it really simple:
The variable:
var pid = DateTime.ParseExact(e.RowData["PLAN_ISSUE_DATE"], "dd-MMM-yyyy", null);

The stored procedure section:
cmd.Parameters.Add("P_DOC_ISSUE_DATE", OracleDbType.Date).Value = pid;