This content has been marked as final. Show 1 reply
You probably need to redesign the form module because it sounds like a maintenance nightmare.
You can create numerous blocks that reference the same table - so I would change your tab1 - block1, tab2 - block2, ... so that each block references the LINES_TABLE. You can then create master-detail relationships between the HEADERS_TABLE and each of the LINES_TABLE blocks. Oracle Forms will then handle the references for you and you will have no problems with inserting, updating, deleting. Once you have these in place you can remove your logic from the ON-INSERT and ON-UPDATE triggers... you would leave logic to populate sequences, creator ids/dates, etc...