Autonomous Transactions

[igon]

I would like to use a data aware form and when calling post have it post autonomously.
For example: I add a patient to a database and while editing the patient I must add his insurance company and I do not want to use another session because of the overhead. On the post of the insurance company I want it committed to the database but not effect the current transaction and maintain data aware.
How do I start and end an autonomous transaction with TOracleDataSet calling post?

 

[Marco Kalter]

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