pragma autonomous_transaction

sinys

Member²
For myself, I added a property "AutoTrans" (Boolean) for TOracleDataset and TOracleQuery. It concludes each operation "Insert", "Update" and "Delete" in block

SQL:
DECLARE
  pragma autonomous_transaction;
BEGIN
  "Insert ..." or "Update ..." or "Delete ...";
  COMMIT;
END;

This is very convenient!
Maybe this should be a property added to the standard DOA?

 
Back
Top