Home » Developer & Programmer » Forms » Record has already been inserted- Error message
Record has already been inserted- Error message [message #211833] Tue, 02 January 2007 09:13 Go to next message
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.

Re: Record has already been inserted- Error message [message #212232 is a reply to message #211833] Thu, 04 January 2007 05:27 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you worked through the Oracle demonstration master-detail tutorial? Have you searched this forum for 'master detail'?

David
Previous Topic: Poplist
Next Topic: text_io
Goto Forum:
  


Current Time: Tue Dec 06 02:47:51 CST 2016

Total time taken to generate the page: 0.12864 seconds