Hi, guys after upgrading Oracle (RedHat 6.2) 8.1.7.0.1 to 8.1.7.3 we have got very strange problem: when I specify commit rollback is occured, you can see bellow.
Code:
SVRMGR>
select to_char(nextattempt, 'yyyy-mm-dd HH24:Mi:ss') from scheduledcalls where schedule_id = 3;
SVRMGR> TO_CHAR(NEXTATTEMPT
-------------------
2003-04-02 16:01:10
1 row selected.
SVRMGR> update scheduledcalls set nextattempt = nextattempt + (retryinterval/86400) where schedule_id = 3;
SVRMGR> 1 row processed.
SVRMGR> select to_char(nextattempt, 'yyyy-mm-dd HH24:Mi:ss') from scheduledcalls where schedule_id = 3;
TO_CHAR(NEXTATTEMPT
-------------------
2003-04-02 16:01:25
1 row selected.
SVRMGR> commit;
Statement processed.
SVRMGR> select to_char(nextattempt, 'yyyy-mm-dd HH24:Mi:ss') from scheduledcalls where schedule_id = 3;
TO_CHAR(NEXTATTEMPT
-------------------
2003-04-02 16:01:10
1 row selected.
There is no job running against of this table, there is no trigger on this table.
The same thing is occured for any column on this table. I created a new table and commit worked correctly on it.
Any ideas about it are very welcome.
Regards,