Not as such. You can download a little (Delphi) demo of a cancelable TOracleDataSet here . The code should be self-explanatory.
The application allows you to enter and execute a query, and to cancel execution. If the dataset has already fetched records when the Cancel button is pressed, a truncated result set will remain.