Invoking ORACLE function

asraj16 · July 25th, 2007, 01:00 PM

Hi,
I created a ORACLE function and need to execute from SQL Server 2005. We created a Link server and executing the following query.

SELECT <LinkServerName>.<Owner>.<FunctionName>()

Could any one help me?

Thanks

happygv · July 27th, 2007, 02:20 AM

Did you forget the database name there?
SELECT <LinkServerName>.<DBNAME>.<Owner>.<FunctionName> ()

Cheers

_________________________
- Vijay G
Strive for Perfection

Jeff Moden · July 27th, 2007, 06:11 PM

And, it MUST be in all caps. But, the real key is, why are you trying to execute a foreign object? Why can't you recreate that function on SQL Server so you don't have to go out on a wing and a prayer?

--Jeff Moden

ind_123 · August 17th, 2007, 09:21 AM

How I can call an oracle function returning TABLE TYPE from SQL SERVER 2000 stored procedure?

planoie · August 20th, 2007, 09:02 AM

Huh? How can you mix Oracle and SQL Server?

-Peter