OraFAQ Forum: Forms » Record has already been inserted- Error message

Home » Developer & Programmer » Forms » Record has already been inserted- Error message

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Record has already been inserted- Error message [message #211833]

Tue, 02 January 2007 09:13

arunsenthild
Messages: 17
Registered: October 2006
Location: Bangalore

Junior Member

Hi all,
pl help me wid this pbm.

i've a item_master table with the following description.
1.item_no
2.item_name
3.unit

and a item_master_dtl table with the following description
1.item_no
2.operation
3.item_sub_name
4.item_sub_code

I'll enter the details of item_master_dtl oly in the modify mode.
when i'm entering the details in the modify mode, while saving, it should insert the item_sub_name and item_sub_code field as item_no,item_name in the item_master table.
i wrote a post-insert trigger to achieve this but while saving this , i get a message called record has already been inserted. no backend triggers r also there.
let me giv an example.

item_master
item_no item_name unit
01 screw Nos

item_master_dtl
Item_no operation item_sub_name Item_sub_code
01 forging forging screw 06
01 threading threading screw 07

while saving this (forging screw,06) and (threading screw,07) should be inserted to item_master as new item.
i wrote insert into statement in post-insert trigger to achieve this, but while saving it is showing record has been already inserted.
Pl help me. its urgent.

Report message to a moderator