Hi Everyone,

Does any one know how to call a database function in command parameter object?

Example:

// conn is a valid OracleConnection object
string sql = "Insert into TableA ( modifyDate) values(:p1)"
OracleCommand cmd = new OracleCommand( sql,conn);
cmd.Parameters.AddWithValue("p1", "sysDate")
cmd.ExecuteNonQuery();

I really want to insert the sysdate into that row rather than the string "sysdate".

I know I can modify my sql like the line below but I really want it to work with parameter object.
string sql = "Insert into TableA ( modifyDate) values( sysdate) ";


Thannks,

JDang