Problem
We were consuming a package in an Oracle Database using the Oracle DB adapter. When we called it we were getting an error about using rollback. We were not using a transaction on the port so not sure why this error was occuring.
Solution
After a little searching we found that the solution was that in the DSN on the work around tab there is an option for enabling MSDTC transaction. This needs to be unticked if you are calling a package/stored procedure which will commit or rollback a transaction.
As it happened in the package they were making multiple inserts and using their own transaction to manage them. Note this was using Oracle 806 so this may not be a problem in newer versions.