p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional Microsoft SQL Server 2014 Administration (http://p2p.wrox.com/forumdisplay.php?f=791)
-   -   call oracle function (http://p2p.wrox.com/showthread.php?t=99326)

arturask January 5th, 2017 05: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 03:34 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.