Devart Forums

Posted: **Tue 08 Aug 2006 14:24**

how can i make one "PRAGMA AUTONOMOUS TRANSACTION" with oracle data access components???

thanks

Posted: **Thu 10 Aug 2006 14:38**

You can set to TOraQuery.SQL or TOraSQL.SQL property a PL/SQL block containing PRAGMA AUTONOMOUS TRANSACTION. Call Execute method of component, and SQL will be executed in autonomous transaction.