Use a temp-table. In your SDO create a temp-table, when the SDO is populated at the same-time populate your temp-table with the ROWID of the records. This will build up a temp-table that matches your query. Then simply at ANY point then you can PRINT / Manipulate the data, you have the ROWID for every record that matches your query.