CODEWITHSUNDEEP
sql-serveroracle-databasedatabase-link
schudel
schudel

Reputation: 1225

Call SQL Server functions via Oracle database link

Is there a way to execute the following statement from Oracle using a database link to a SQL Server instance without having to create a view on the target instance?

select db_name(), @@SERVERNAME

I have tried

"select db_name(), @@SERVERNAME"@DbLink

but that did not succeed.

Any help would be greatly appreciated

Upvotes: 0

Views: 4346

Answers (1)

Alberto Garcia E.
Alberto Garcia E.

Reputation: 51

Here:

select dbo.FunctionName@dblink('value') from dual;

But you need to tell the dblink which functions must be available through the dblink. See the manual at: http://docs.oracle.com/cd/E11882_01/server.112/e11050/admin.htm#i1007467

Upvotes: 1

Related Questions