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