• 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