Savepoint problem

[scw2hi]

Hi,

I´m using ODACs 6.90.0.54 with RAD Studio 2010 (C++)

Code: Select all

main->ora_session->StartTransaction();

otb_data->Edit();

This creates a savepoint named "LOCK_otb_data"

Then I change some data related to the currently locked entry
In previous version I was able to overwrite the savepoint "LOCK_otb_data"
My problem now this does not work any longer and posting the original edited object rolls back to savepoint.
Afterwards my edits are gone.

Can you help?!

[scw2hi]

Each new ora_session->Savepoint("Test")
creates a new Savepoint entry in DBMonitor but without any name!

So a new savepoint seem to overwrite the previous one without careing about its name

[kurtbilde]

Hi,

Looks like the issue I stumbled upon in august... (Search for Ora-1086 error). The problem was never found by Devart, even though ODAC did create it's own errormessage dialog. Does it raise an ORA-error or ?!?

All the best
Kurt

[scw2hi]

Hi,

I haven´t seen any ORA error message so far.

The only thing I can see is that all manually created savepoints are sored on ora_session without any name.

[Plash]

We have fixed this problem. The fix will be included in the next build of ODAC.

[scw2hi]

That is great ,

thanks in advance