hi ,
i am using oracle forms 6i ,
there is a table with composite primary key (order_id , item_id ) ,
if i try to insert a duplicate record , i face frm-40508 because of ora-00001
so , i wrote this code in my " on-error " trigger to avoid the error
IF ERROR_CODE = 40508
AND
DBMS_ERROR_CODE = '00001'
THEN
MESSAGE('you have entered a duplicated record ') ;
MESSAGE('you have entered a duplicated record') ;
END IF;
then , when i try to insert a duplicate in order to see the message above in my code , i see nothing ,
, even do not see the original error , nothing happens , and does not save anything .
what could the problem be ?
thank you so much .