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.