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

  • 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.

  • I would expect

    Declare @OrderID Int

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

    if I read correctly (link)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply