p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional Microsoft SQL Server 2014 Administration (http://p2p.wrox.com/book-professional-microsoft-sql-server-2014-administration-791/)
-   -   call oracle function (http://p2p.wrox.com/book-professional-microsoft-sql-server-2014-administration/99326-call-oracle-function.html)

arturask January 5th, 2017 04:04 AM

call oracle function
 
How i need to call oracle function with ref cursor output in mssql from linked server?
i use this script
SELECT *
FROM OPENQUERY(oracle ,
'select * from functionname(''N'',''2016-11-01'')')
but i get 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???


All times are GMT -4. The time now is 11:00 PM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.