User Profile

Collapse

Profile Sidebar

Collapse
cthomas7k
cthomas7k
Last Activity: Oct 31 '12, 03:38 PM
Joined: May 10 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cthomas7k
    replied to How to get a c# DateTime accepted into an Oracle stored procedure
    in C Sharp
    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.ParseE xact(e.RowData["PLAN_ISSUE_DAT E"], "dd-MMM-yyyy", null);

    The stored procedure section:
    cmd.Parameters. Add("P_DOC_ISSU E_DATE",...
    See more | Go to post

      Leave a comment:

    • cthomas7k
      started a topic How to get a c# DateTime accepted into an Oracle stored procedure
      in C Sharp

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

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

      I have been surfing for 3 days trying...
      See more | Go to post
      No activity results to display
      Show More
      Working...