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???