Thanks Phil,

We coded to_date('" & arguments.date_time_received & "','yyyy-mm-dd
hh:mi:ss')" in the pl/sql procedure and simply passed the date_time_received in
CF_SQL_TIMESTAMP format and the problem is solved. Thanks.

Lisa