SQL & PL/SQL

Hi Gurus,

I am having an issu using dbms_job and dbms_scheduler.

both dbms_job.submit and dbms_scheduler.create_job does an implicit commit.

I am able to embed the dbms_scheduler.create_job in a package. procedure which is autonomous transaction. But that is not possible in case of dbms_job.

In spite of embedding it in autonomous transaction, irrespective of whether commit exists or not in my procedure being called by the scheduler all transactions are committed.

Can I have a work around for this? I can't make changes to my existing procedure(called by the scheduler).

Thanks and Regards,