The suggestion re enabling "Allow inprocess" on the provider solved our problem, thanks!

We enabled the following options on the OraOLEDB.Oracle service provider and restarted the database instance:

– Dynamic parameter

– Nested...