This content has been marked as final. Show 8 replies
Are you basing your block on a table or you are populating record manually on forms block ?
yeah ,basing on a table
https://blogs.oracle.com/shay/entry/10_commandments_for_the_otn_fo1 person found this helpful
Your form version and other details would be much helpful
If you delete and commit normally record will be deleted from table. Any error are you getting when you run this code?
FRM-40508 : ORACLE error: unable to INSERT record !!!
any solutions ?
When error happens go to1 person found this helpful
Help> Display error
Post the error here
ORA-00001: violation de contrainte unique (SYSTEM.CL_P_GR)
You have unique key field(s) on the table you are trying to insert which actually restricts you from inserting the same value again.1 person found this helpful
When you are deleting the record and issue commit there is a record to be inserted in the table which is a duplicate that's why you are getting this unique error.
As oracle is not able to insert your commit fails and stops your deletion of record from table
problem 's solved ,because i made wrong in the code of insertion :)
Edited by: 979155 on 31 déc. 2012 14:06
Edited by: 979155 on 1 janv. 2013 14:43
Edited by: 979155 on 1 janv. 2013 14:44