Database Trigger and Service
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