I am in a transaction and need to do an autonomous transaction within that transaction. For example: The program is adding a client. While adding the client one may need to add an insurance company from that screen but if the client screen is canceled I still want the insurance company information saved. How would I accomplish this with the doa components.
Autonoumous Transactions
- Thread starter igon
- Start date
There are several alternatives for this. If you are using Oracle8i, you can use the autonomous_transaction pragma in a PL/SQL block or PL/SQL stored program unit to add the insurance company. If you are not using Oracle8i, you can either use a secondary session to add the insurance company, or you can arrange it so that the insurance company transaction is finished before the client transaction starts.
------------------
Marco Kalter
Allround Automations
------------------
Marco Kalter
Allround Automations
