ORA-22990: LOB Locators cannot span transactions

rbuser

Hi,

I am loading templates from BLOB fields into a TppReport object using
LoadFromDatabase. The template is presented in a TppDesigner object
(ShowModal) so that the user can edit the template. Loading and saving
templates works fine except for occasionally when the users get "ORA-22990 :
LOB Locators cannot span transactions".

It seems like this happens if a user opens a template for editing in the
TppDesigner object and then leaves it open for a while. Is there any timeout
that can occure?

Any idea where I should start looking?

Regards,

Arvid Haugen

nicocizik

Arvid,

There is no timeout function of ReportBuilder. This is a data access
component or Oracle issue. Perhaps try checking the configuration of your
data access session component and also your database admin for a timeout
settings.

--