Skip to Main Content
Forums

SQL & PL/SQL

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!

DBMS_SCHEDULER and Trigger

user458361May 8 2012 — edited May 9 2012
Hi,

I have requirement to write a oracle trigger on a table, which invokes a shell script.
My idea was to use DBMS_SCHEDULER . but i read in some articles that it may throw the exception SQL Error: ORA-04092: cannot in a trigger and it does an internal commit unlike DBMS_JOB.
please suggest if there any alternate solution.

Thanks
Ben
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2012
Added on May 8 2012
5 comments
1,253 views