I am getting this error FRM 40508 in inserting data to any table through forms 11g.
my test table having two columns : id and name
i wrote a simple insert statement
insert into test values (:id, :name);
when i run the application and insert the values, it shows the above error.
when I use the display errors , it shows that there is a violation : ora - 00001 (duplicate values)
however, there is no such value in the database.
The same scenario is repeating with every table I have. Please help !
Perhaps that's not the problem : Even if I enter any other value... still the same problem exists. That's why I'm not able to understand this... If I run the same insert statement via SQL plus or SQL developer, it works fine !
I'm not able to judge what's going on here. Please help !
I would guess that your block is based on the same table you use in your manul insert. If so, the solution is quite easy. Do simply do not need the manual insert. forms does that DML-stuff on itself. It recognizes that you created a new record, and when you issue a COMMIT_FORM, it will generate the apporpiate insert and send it to the database.
I was telling same thing as Andreas
Why do you want to insert yourself when form does it automatically. You use manual insert when you can not do it using forms automatic functionality.