Does anyone have experience of successfully configuring workflow (10.2) to connect to an Oracle data source?

I was trying to set this up the other day for a client and the results were very mixed. It seems to be an issue related to 32 bit and 64 bit drivers but we get differing causes of failure with each.

Using the 64 bit Oracle Client (11.2) and the Oracle ODBC driver, the list of tables/views fails to load due to an arithmetic overflow error. We switched to the 32 bit Oracle client and in design time mode (i.e. testing the query using sample data) it makes the connection and returns the x number of rows. However, at runtime we get an error stating that the Oracle version must be version 8.1.7 or higher and the lookup fails.

Workflow itself is the 64 bit version (all the installed files are in Program Files\Laserfiche rather than Program Files (x86)\Laserfiche. 

Does anyone have any advice on which versions of which components should work? I've tried using the Oracle ODBC dirver only so far, not sure about the ODP driver, or whether we should/could install the Oracle Data Access components?

Any advice appreciated!