Managing Transaction in Direct Mode [resolve]

ChristopheF · Post by **ChristopheF** » Wed 23 Apr 2008 09:22

I wonder to know if there is anyway to manage Commit, Rollback transaction when using OraSession in direct mode. As I understood it seems there is no cache updates in this mode. Is this mean that all your statments are directly posted to the DB and there is no way to rollback your work in this mode?

Thanks for your answear.

Plash · Post by **Plash** » Wed 23 Apr 2008 14:10

Transactions are Oracle server feature. They are supported in Direct mode same as in OCI mode.

ChristopheF · Post by **ChristopheF** » Thu 24 Apr 2008 08:18

Thanks for the very fast reply.

In fact because I'm a new ODAC component user I wanted to use the TOraTransaction like the way I was working with ibExpress component. This component was giving an error saying that it does not work with direct mode. After I saw the InTransaction and Comit Rollback method on TOraSession and I didn't find time to update the topic saying I found the solution.

Thanks again for the answear.