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
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.

and a item_master_dtl table with the following description

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_no item_name unit
01 screw Nos

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
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you worked through the Oracle demonstration master-detail tutorial? Have you searched this forum for 'master detail'?

Previous Topic: Poplist
Next Topic: text_io
Goto Forum:

Current Time: Wed Jul 26 07:44:29 CDT 2017

Total time taken to generate the page: 0.84597 seconds