I'm calling an update procedure in Oracle
<pre>
With objCommand
      .CommandText = "{call cust_Update(?, ?, ?)}"
      .CommandType = adCmdText
      .Parameters(0).Value = varCus_id
      .Parameters(1).Value = varf_Name
      .Parameters(2).Value = varbirthdate
      .Execute() ............
</pre>
the problem I'm having is entering the birthdate. This is the error
Microsoft OLE DB Provider for Oracle error '80040e14'
I believe it has something to do with the delimiter in the date string("/"), but not sure? The Oracle procedure birth_date column is in "mm/dd/yy" format:
birth_date=to_char(i_birth_date,'mm/dd/yy')....
When I pass this in the textbox in this format I get the error? How can I resolve the ASP to take in the right characters for the birthdate?
Thanks...

You can easy send date parameter as string and convert it to the date type inside store procedure using TO_DATE(CHAR [,FMT])function.

Jon.

http://www.allamericanjobs.net