woops... never mind, found it. The VFP Ole DB Provider Data Support doc says that VFP date type DateTime maps to Ole DB type DBTYPE_DBTIMESTAMP. Since the Oracle Date type maps to DBTYPE_DBTIMESTAMP, I figured the VFP DateTime() function is good to supply the value. Works great. Great idea these Ole DB types.

** Set up adDBTimeStamp IN parameter
Param0 = oCom.CreateParameter("v_from_date",135,1,30)
oCom.Parameters.Append(Param0)

** Set the val
oCom.Parameters(0).Value = DATETIME(2002,10,10)