I am having a problem when I try to use:

SET TRANSACTION USE ROLLBACK SEGEMENT RB7
delete from results_storage_history
where result_time <= to_date('01-FEB-02', 'DD-MON-YY');
commit;

I keep getting error message saying that "delete from results_storage_history" was not properly ended. However when I do not use the SET Transaction command it runs and I get rollback too small errors.

Any ideas? Thanks