I have a TOracleDataSet that has a SELECT
statement that uses several databases eg:
SELECT project_no
FROM ledger l
UNION
SELECT project_no
FROM ledger@db.melbourne.home.com l
UNION
SELECT project_no
FROM ledger@db.sydney.home.com l
This query's results are used in a Quick Report. However, after the report has been closed, a transaction TX lock that Oracle created is not released. From reading around I believe that it is necessary to commit even SELECT statements due to two-phase commit used for distributed databases.
However, have tried using the OracleSession.Commit directly after opening the query but this has no affect.
Any advice greatly appreciated.