SSIS Error with OLE DB Command to Oracle

Hello Experts Exchange
I have a SSIS package that has a ADO datasource to MYSQL, it then does a lookup to Oracle, the match data then goes to a OLE DB Command to update the records.

The OLE DB Command is running this script.

Update SITE_INCOME 
Set SI_AMOUNT_BANKED = ?,
    SI_BGC_NO = ?
Where SI_ID = ?

Select all Open in new window

But when I click Refresh in the OLE DB Command I get the following error message;

Error at Data Flow Task [OLE DB Command [99]]: SSIS Error Code DTS_E_OLEDBERROR. AN OLE DB error has occurred. Error code 0x80040E30.

An OLE DB record is available. Source "Microsoft OLE DB Provider for Oracle" Hrsult: 0x80040E30 Description: "Type name is invalid.".

Error at Data Flow Task [OLE DB Command [99]]: Unable to retrieve destination column descriptions from the parameters of the SQL command.

Select all Open in new window

I have googled the error code 0x80040E30 , but have found nothing.

Can anyone suggest something I can try to get this working please?

Regards

SQLSearcher