what is the timeout for distributed transactions on your system? (i think heard somewhere that the default is one minute)
if the problem is only occasional, is it possible that another user is also setting up a distributed transaction, thereby causing yours to exceed the limit of permitted transactions? Kamp, Rolf F, ALCNS wrote: >Hi: > I have one distributed transaction in my code that performs a query using a >method in another DB. Something in our system is causing my code to occassionally get >the Oracle error: > >ORA-02042: too many distributed transactions > > When I end my program I call commit() but I don't call disconnect(). My >question is by NOT calling disconnect() and just treminating my program, does DBI >close the connection to the database? I will put the call to disconnect() in, but >would like to know if it will be of any use in this instance. > > I'm running DBI 1.13 with perl 5.003 on Solaris (7) using Oracle 8.1.6. > > TIA >- Rolf. > -- Morris Paterson, PhD [EMAIL PROTECTED] Inpharmatica www.inpharmatica.co.uk 60 Charlotte Street London W1T 2NU Tel: +44 (0)20 7074 4690 Fax: +44 (0)20 7074 4700
