Hi,
Using 11.2.0.3 and have a pl/sql pacakge which calls a remote procedure on another datbaase.
The remote procedure inserts rows into reote table and the remote procedure has a commit in it.
Then the local procedure tires to read the renote table for the inserted record but doesn't see it
Rows definitely get inserted in remote table just not visible to local procedure until next run of loacl procedure
local procedure
e.g
calls remote procedure
select prod_num
into v_prod_num
from remote_table@link_name
raises no_data_found exception.
Had expected local procedure to be able to see this but as if despite commit in remote proecdure its view of the data is the one at time thelocal procedure runs rather than being dynamic.
Is there any way to chnage this?
Thanks