InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:34:58 GMT20http://www.teradata.com/teradataforum/Topic6541-12-1.aspxPassing NULL values to a TERADATA sp, using Teradata .NET provider <br><br><br> Teradata provides Teradata .NET provider driver for connecting to Teradata using .NET 2.0,<br>I was initally using ODBC driver, but for calling SP using CommandType.Text or CommandType.StoredProcedure, both do not return any value, so we switched to Teradata provider provided by NCR corporation . ( Can ODBC driver be used for retrieving the SP return value ??? )<br><br>But I was a facing a problem related to passing NULL values to the SP.<br>The documentation provide to use DBNull.Value, but this works perfectly well for DATE and TIME type parameters but not for STRING type parameters, where the system gives the exception NULLReferenceException.<br>This SP works pefectly well with NULL values by using NULL values in Teradata SQL Assistant.<br><br>I have even tried using parameter values as NULL,'NULL',"NULL" but all fail for one or the other parameter types, sometimeg giving Invalid DATE and time and for string types.. not accepting it as a NULL but instead as a blank space.<br><br> If I need to be more elaborate, please do tell me..<br>I can paste my code as well..<br><br>Help needed is urgent.<br><br>ThankTue, 13 Feb 2007 05:52:37 GMTabir_seth