Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

execute procedure/function on linked Oracle server from MS SQL - message “ORA-01008: not all variables bound” Expand / Collapse
Author
Message
Posted Thursday, May 29, 2014 7:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 30, 2014 10:12 AM
Points: 1, Visits: 12
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.
Post #1575572
Posted Friday, May 30, 2014 2:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 1,386, Visits: 6,251
I would expect
Declare @OrderID Int
Exec ('Call DATALIB.BP_PUSH_F(?)', @OrderID OUTPUT) AT ERP

if I read correctly (link)
Post #1575978
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse