I linked Oracle server on MS SQL. Simple function (and procedure) is created on Oracle - only to return number. I am trying to cal this function(procedure) from MSSQL. When I try to execute function (or procedure)
DECLARE @outputpar int
EXECUTE ('BEGIN ? := BP_PUSH_F(?); END;', @outputpar OUTPUT) at ERP
i receive message:
OLE DB provider "OraOLEDB.Oracle" for linked server "ERP" returned message "ORA-01008: not all variables bound".
Msg 7215, Level 17, State 1, Line 18 Could not execute statement on remote server 'ERP'.
ERP is the name of the linked Oracle server.
Function on Oracle server is:
create or replace FUNCTION BP_PUSH_F RETURN numeric AS
v_id := 111;
and normaly works on Oracle. Can anybody help? Thanks in advance.