Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

executing dbms_scheduler.run_job within the trigger

user550338Jan 10 2014 — edited Jan 11 2014

Hi, I have dbms_scheduler.run_job('blah') and it ran fine when I executed manually in SQL; however, I would like to execute this job within the trigger and it's not working. both, job and trigger are owned by SYS. Can someone please tell me what happened and solution? Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2014

Added on Jan 10 2014

#general-database-discussions

6 comments

1,662 views