How to pass Date time Field blank value in c# and Oracle Procedure?
This is My Object Code..............
public class kNewCustomerinformation
{
private DateTime? trade_lice_dt=null;
private DateTime? reg_dt=null;
private DateTime? comm_Business_dt=null;
}
This is My Oracle Procedure.............
CREATE OR REPLACE PROCEDURE SA.WSP_INS_CRM_CUSTOMER
(
VTRADE_LICE_DT IN DATE,
VREG_DT IN DATE,
comm_Business_dt DATE
VVMSG OUT VARCHAR2 ,
VVMSG_CODE OUT VARCHAR2
)
Then Insert Table and pass parameter variable value.
And my Dataservice Pass Parameter Value
fbDataAccess.FBWDatabase.AddInParameter(dbCommand, "VTRADE_LICE_DT", DbType.DateTime, objIndividualCustomerInformation.trade_lice_dt);
fbDataAccess.FBWDatabase.AddInParameter(dbCommand, "VTRADE_LICE_DT", DbType.DateTime, objIndividualCustomerInformation.reg_dt);
fbDataAccess.FBWDatabase.AddInParameter(dbCommand, "VTRADE_LICE_DT", DbType.DateTime, objIndividualCustomerInformation.comm_Business_dt);
fbDataAccess.ExecuteInsert(dbCommand);
When Execute this sp then exception "ORA-01036: illegal variable name/number".
How can pass blank Value date field.
Please Help me.