deleting and rolling back in a sbmitted job

 HI

I have a DBMS_JOB.SUBMIT that will run a proc to delete records. I ran the submit and all went well.

It did delete all the records I wanted. I had the COMMIT statement blocked out in the proc that was to delet the records. I see now that the records I deleted cannot be rolled back. It this right? Ill assume Ill need to hardcode ROLLBACK in the delete proc to prevent this "commit". I hate reentering those test recs.
If I roll back(hardcode) in the submitted proc...I cant query to see if they were actually deleted....because they will have been rolled back.......shoot

jwa Received on Thu Sep 15 2005 - 14:52:01 CDT