View Single Post

   
  #3 (permalink)  
Old 02-25-2008, 04:20 AM
EdStevens
 
Posts: n/a
Default Re: ORA-00036 maximum number of recursive SQL levels (string) exceeded


Joel Garry wrote:
> Kind of a reach, but are you tracing?
> https://metalink.oracle.com/metalink...,1,1,helvetica
>
> Just for jollies, check MAX_TRANSACTION_BRANCHES and
> DISTRIBUTED_TRANSACTIONS on the 8 side (though it looks like the 10
> side is throwing the error - are you sure it doesn't have more links?).
>
> I think you are going to have to have a 9 in between.
>
> jg
> --
> @home.com is bogus.
> http://www.wired.com/news/culture/0,...l?tw=rss.index


Thanks for the reply, Joel.

Yep, I tried tracing, and also messed with DISTRIBUTED_TRANSACTIONS on
the 8 side. Tried bumping it up to 80, also tried reducing it to zero.
No impact either way. I knew this was a long shot, but I always work
under the assumption that "there are unknown unknowns" so hate to give
up without checking around.

Reply With Quote