SQL Server >> Synonym to External Databases (Oracle)
> Is it possible to create Synonym of Oracle Procedures & Objects in SQL
> Server 2005 and if so will they work through a DBLink.
Oh, for procedures you can't create synonyms, but you can call the
procedures with the EXEC ... AT syntax
And you can write a wrapper stored procedure in SQL Server that executes the
remote procedure. This would work basically like a synonym. The Oracle
sored procedure will need to use SQL scalar inputs and outputs, however. No
PL/SQL types, object types, ref cursors, etc.