Hi!

  I never worked with Oracle before. Anyway:

On 2010/09/24, at 17:50, Ken Anderson wrote:

> The data type of the trans_id column is Number (12,0)

  Is that an integer or a float? If it's float, then there's your problem. :)

> It's Oracle RAC, so yes, a cluster.

  Could it be that you are writing a row to one server and reading the same row 
immediately after from another server that still didn't receive the update?

> Yes, no way for someone else to change those rows, since we audit the tables 
> with a trigger, and they weren't modified by anything else. 

  Could it be that your trigger is somehow running after the transaction 
commits and doing something nasty to the transaction_id?

  Regards,

Miguel Arroz _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to