ORA-03127 no new operations allowed until the active operation ends ...
630648Jan 14 2009 — edited Jan 14 2009Hi,
I am working in forms 10g (web based )
In my form I designed customer master with Query, Addition, deletion, Cancel and Exit buttons coding designed and verified one by one. same coding working in 6i design.. based upon 6i model i created new form in 10g it is giving trouble... ?
In Deletion button I am trying to update the record like status = ‘Y’ commit_form ; record is updated in the Database table but forms is showing given below error and not accepting any entries, Totally forms behavior is changed .. and giving same error in all buttons.
ORA-03127 no new operations allowed until the active operation ends
Cause: An attempt was made to execute a new operation before the active non-blocking operation completed or a new operation was attempted before all the pieces of a column were inserted or fetched.
Action: Execute the new operation after the non-blocking operation completes. If piecewise binds/defines were done, execute the new operation after all the pieces have been inserted or fetched.
Many times I designed facing the same problem, How to solve this problem? I tried to roll back, or updated status = null no way for me .. How to solve? Or any one has 10 g forms example with delete option?