Which Oracle driver are you using? Are you sure it supports OLE DB parameter mapping?
A simpler option may be to build your SQL Statement using an Expression in a Variable, and then just mapping the Variable to the SQLStatementSource property of the Execute SQL Task.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato