Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error on insert trigger

134789Apr 12 2005 — edited Apr 14 2005
[System.Runtime.InteropServices.COMException : SQL execution error, ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: in "LPK.OVM_INSERT_214", Line 173
ORA-04088: error on executing trigger 'LPK.OVM_INSERT_214'
]

This error occurs on a versioned table, where much delete and insert statements executed! In some cases a line was delete and after a time, the same line with a other content but the same primary key was inserted!!

On one of these inserts this error occurs!

Who can me help?

cu

Andreas Kunze

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2005
Added on Apr 12 2005
3 comments
2,493 views