Last post Feb 10, 2011 08:59 AM by dot net expert
Feb 10, 2011 05:04 AM|swapna.anu|LINK
Can any one help me how can I pass empty string to oracle number datatype. Oracle procedure accepts null but its throwing error when I pass null from C#.
Please let me know how to pass null value to number datatype.
Thanks in advance.
Feb 10, 2011 06:04 AM|swapna.anu|LINK
Got this to work.
Feb 10, 2011 08:59 AM|Dot Net Expert|LINK
This is a general problem, not just for number datatype. You can only pass a NULL as a value to any of your fields if the given field is nullable (this means that your field accepts null as a value). You must alter your table and modify your column to be
nullable. After you've done so, you won't have this problem. Note, that this is not just a problem for number datatypes, if you have any datatype, you can only set it's value to null if that's possible.