View Single Post
  #1 (permalink)  
Old January 5th, 2017, 04:04 AM
arturask arturask is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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???
Reply With Quote