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!

Call JTF API from within a DB trigger

MikeOBIAug 18 2009 — edited Aug 19 2009

Hi,
I'd like to call the following API jtf_tasks_pub.create_task to create a Task, whenever a row in 1 of our bespoke tables is updated.

So I have created an after update database trigger, when the row is updated the trigger calls a procedure that is using PRAGMA AUTONOMOUS_TRANSACTION but the API fails with a return status of 'U'. If I call the API directly from a stub it works OK.

Should I be able to call the API in this manner, anything obvious I might be missing?

Thanks,

Mike

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2009

Added on Aug 18 2009

5 comments

1,112 views