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,