i have a database block on my form. the table to which it belongs is having one field naming - 'RETURN' .
so at the time of insertion it is giving error as Oracle error-Unable to insert record' and the error is unique constraint violated, but at the same time the record is getting inserted into the database.
can anybody tell me st abt this behavior of forms and also how can i suppress the database error window poping up on screen.
(system.message_level doesn't help).
forms 6i ,oracle 10g
November 13, 2009 11:01 AM
November 13, 2009 4:47 PM