ora-2067 transaction or savepoint rollback required
I have a situation where one procedure in one db needs to call another. The called proc will execute a process of inserting records into a table on the called db. Then the calling proc would run a query on the table from the called db and posit it on another db (using db links of course).
I have setup the called procedure as an autonomous transaction, used "set transaction read write" but I still get this error. None of the instances on the net get very concrete about how to solve this sort of problem so I am left in a quandry. Does anyone have any ideas how to specifically solve this sort of thing?
Steve