Oracle Forms 6i - Master-Detail - On inserts, info getting rolled back
From: devdewboy <devdewboy_at_hotmail.com>
Date: 12 Aug 2004 17:32:43 -0700
Message-ID: <2686cda2.0408121632.76f2c2bf_at_posting.google.com>
Froms 6i - I have a Master-Detail relationship, 1 master and 4 detail tables to the master. Now when I query a record and update one or more of the detail records and SAVE the info gets commited. If I add a new detail to any one or all of the detail blocks, the information is not getting saved; in fact I checked the SGA out and the insert statement is being issued but seems to be getting rolled back as I see a ROLLBACK in SGA for the form's session and I never once issued the ROLLBACK command.
Date: 12 Aug 2004 17:32:43 -0700
Message-ID: <2686cda2.0408121632.76f2c2bf_at_posting.google.com>
Froms 6i - I have a Master-Detail relationship, 1 master and 4 detail tables to the master. Now when I query a record and update one or more of the detail records and SAVE the info gets commited. If I add a new detail to any one or all of the detail blocks, the information is not getting saved; in fact I checked the SGA out and the insert statement is being issued but seems to be getting rolled back as I see a ROLLBACK in SGA for the form's session and I never once issued the ROLLBACK command.
What could be causing this situation? Some tips to look for would be good.
You can email me at devdewboy_at_hotmail.com
Thanks! Received on Fri Aug 13 2004 - 02:32:43 CEST