I'm seeing some strange behavior in connecting to our Oracle database.
Basically what is happening is that I perform an update of a field and
then immediately (within a few seconds) perform a search for that same
record/field the value returned from Oracle is the pre-update value. If
I wait a little longer (maybe 5-10 seconds) and perform the search again
(without repeating the update) the value returned is the post update value.
My interpretation is that this looks like some kind of transaction or
caching issue, although we are set to auto-commit after each update,
which should address the transaction problem.
Do you have any ideas about what might be causing this problem, and how
we could identify further the cause and resolve it.
I'm not certain how long this may have been occurring.
DB - HESPRD
Witango 5.01.065
Mac OS X 10.3.8
thanks,
Maggie Pinckard
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
