Hello - I have to call a function over a DB link.
The following works:
SELECT ABCABC.CalcRTU@qa4db.world('6180PM'ABC.F@qa4db.world(ABC.FU@qa4db.world(ABC.FUN@qa4db.world(.FUNC@qa.world(ABC.FUNC@qa4db.world(parameters) from dual;
However, we have 4 different environments to push this code into and each environment has a different name for the db link. So I would really like to replace that with a synonym that I can just propogate through the various environments. That way our package, which calls the function, does not need to change for each environment. I've tried many different ways, but with no success. Does anyone have any suggestions? Thank you!