I use TOracleDataset with RefreshOptions=[roAllFields] and following SQL (for example):
SELECT emp.ROWID FROM Scott.emp, Scott.dept
where dept.deptno = emp.deptno AND emp.sal < 5000
after opening the dataset I execute RefreshRecord method.
As result, I see in Oracle Monitor my query with...