Hi All,
I have a two databases test and live.
If i issue a command like this to select the following field it works .
select cards.get_principal_card('2879290') Loyalty_card
from dual;
The get_principal_card is the function in card package which retuns the card number. This is executed properly.
If i execute the statement over a dblink like follows. it is giving the error as ora-00980-synonym translation is no longer valid.
select cards.get_principal_card@crmlive('2879290') Loyalty_card
from dual;
How should i use the dblink to get the data from live??
Thanks