Calling a SQL Server SP in PL/SQL
503458Dec 15 2009 — edited Dec 16 2009I'm currently struggling to execute any remote stored procedure (SP) on the remote MS SQL Server system from Oracle.
This is where I'm currently at and if I'm not mistaken this call should be correct:
---------
desc "dbo"."GetIdByLoginEmail"@mssql
PROCEDURE GetIdByLoginEmail"@mssql
Argument Name Type In/Out Default?
@login VARCHAR2 IN
@email VARCHAR2 IN
result_set_handle REF CURSOR OUT
*variable r refcursor*
*exec "dbo"."GetIdByLoginEmail"@mssql('test','test@test.com',:r)*
BEGIN "dbo"."GetIdByLoginEmail"@mssql('test','test@test.com',:r); END;
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL][A04B] Wrong number of parameters passed to saved query spec
dbo.GetIdByLoginEmail(). It has 3 parameters and not 2 as specified.
ORA-06512: at line 1
----------
Anyone have an idea why this call is failing? I can't find a lot of resources out there concerning this.