Calling an Oracle function from SQL Server Linked Server

I used the following syntax and it worked for me.

EXECUTE (Query, Parameters) AT LinkedServerName
Example:

EXECUTE ( 'BEGIN ? := Package.MyFunction(?,?); END;', @ReturnValue, @InputPara, @OutputPara OUTPUT ) AT LinkedServerName
Important Points:

Don't forget the BEGIN and END syntax when calling functions
Don't forget the semicolon at the end "END**;**"
For using the above syntax you need to enable RPC for the linked server
Oracle will not consider the call as a function call unless you accept the output in a variable

点击打开链接