Call Oracle function with ref cursor output in SQL Server linked server?

Question

How do I need to call an Oracle function with ref cursor output in a SQL Server linked server?

I used this statement:

SELECT *
FROM OPENQUERY(oracle, 'select * from functionname(''N'',''2016-11-01'')')

but I get this error

OLE DB provider "OraOLEDB.Oracle" for linked server "oracle" returned message "ORA-00933: SQL command not properly ended".

Msg 7321, Level 16, State 2, Line 33
An error occurred while preparing the query "select * from functionname('N','2016-11-01')" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "oracle".

Any help?

Community · Accepted Answer · 2017-05-23 10:30:37Z

0

Maybe this will help? Calling an Oracle function from SQL Server Linked Server

EXECUTE (Query, Parameters) AT LinkedServerName

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Jan 5, 2017 at 10:40

Petter Soderlund

1021 silver badge9 bronze badges

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

1 Comment

Artūras Kučejevas Over a year ago

I tryed it but my output is ref cursor and mssql don't have this type

Collectives™ on Stack Overflow

Call Oracle function with ref cursor output in SQL Server linked server?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related