Hi,
Were you able to call the oracle funtion from SQL Server?
I have the same issue.
I have to call Oracle function with 1 input and 1 output parameter, but it always gives some or other syntax error. If you know the exact syntax, please let me know.
I tried these ways-->
declare @InputPara varchar(100)
set @InputPara=’Hello’
declare @OutputPara bigint
EXECUTE ( ‘BEGIN ? := packagename.functionname(?,?); END;’, @InputPara, @OutputPara OUTPUT )at linkedservername;
select * from linkedservername..packagename.functionname(‘Hello)
select * from openquery
(
LinkedServerName,
‘SELECT * FROM packagename.functionname(”Hello”);’
)
Thank you so much -Janki