ORA-20006: ORA-20001: ORA-08177:can't serialize access for this transcation

[zeeshan]

Hi
I have Oracle 9i version 9.0.1.1.1.
I have forms and report developed in Developer 6.
When we update or insert record these record are updated in lots of tables so triggers are used.
Some time when when update or insert record this error occurs and it says

ORA-20006: ORA-20001: ORA-08177: can't serialize access for this transaction

ORA-04088: error during execution of trigger



Now we have check our triggers and there is should be no problem in it.

Some one was saying its some kind of bug in Oracle.

Can Any one Plz help!
I am really desperate.

Regards,

Zeeshan

[slimdave]

It's not a bug, it's an issue with use of serializable transactions. What it means is that your application attempted to update table values that had changed since the time that the transaction started. Since that would not be a safe operation, the modification fails.

Tom Kyte has an explanation in this thread

[zeeshan]

Thanx for ur reply

Some body told me to increase INITRANS of the table involved.
Will this work and how can do this.

Also I cannot change the SQL statements because our Developer are quite stubborn they wont allow it.

Any more ideas

Plz I really need help.