execute procedure/function on linked Oracle server from MS SQL - message “ORA-01008: not all variables bound”

• vladimir.popadic

  SSC Enthusiast

  Points: 153

  More actions

  May 29, 2014 at 7:26 am

  #287060

  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 numeric;

  BEGIN

  v_id := 111;

  RETURN(v_id);

  END BP_PUSH_F;

  and normaly works on Oracle. Can anybody help? Thanks in advance.

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  May 30, 2014 at 2:57 am

  #1717688

  I would expect

  Declare @OrderID Int

  Exec ('Call DATALIB.BP_PUSH_F(?)', @OrderID OUTPUT) AT ERP

  if I read correctly (link)