Skip to Main Content

Integration

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!

Database Trigger and Service

jtyremanJan 9 2013 — edited Jan 9 2013
Hi all,

being struggling with this for the past couple of days...

I have a database trigger that fires when a new row is inserted into a table it calls a service and sends over the main "ID" of that row, the SOA Service then using a Database adapter within a BPEL process selects that row using the data passed into the service,

however it does not find the database record, if i insert the same record again it does find it on the second time round (Presumably picking up the first entry)

the trigger is a "ON COMMIT" trigger so not sure what its doing

can anyone help?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2013
Added on Jan 9 2013
1 comment
260 views