"PRAGMA AUTONOMOUS TRANSACTION"

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
niniramos
Posts: 11
Joined: Tue 04 Jul 2006 07:40

"PRAGMA AUTONOMOUS TRANSACTION"

Post by niniramos » Tue 08 Aug 2006 14:24

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

thanks
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » 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.
Top
Post Reply

Return to “Oracle Data Access Components”