Call SQL Server functions via Oracle database link

Question

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

possible duplicate of Run SQL Server Stored Procedure via Database Link from Oracle — Sathyajith Bhat
– Sathyajith Bhat, Commented Jan 19, 2012 at 9:19

cchapman · Accepted Answer · 2016-05-03 18:47:13Z

1

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

edited May 3, 2016 at 18:47

cchapman

3,38510 gold badges56 silver badges72 bronze badges

answered May 3, 2016 at 18:26

Alberto Garcia E.

512 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

schudel Over a year ago

Thanks. As I no longer work in a company that uses Oracle I cannot test it. Have upvoted your answer though.

Collectives™ on Stack Overflow

Call SQL Server functions via Oracle database link

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related