I had this question after viewing How to call an Oracle Stored Procedure within SQL Server ?
This is the Oracle Procedure:
CREATE OR REPLACE PROCEDURE PPC.PRUEBA_CHAR ( OUT_SALIDA1 OUT VARCHAR2 )
WHEN OTHERS THEN NULL;
When I try to run it from Sql-Server with this:
DECLARE @DATA2 VARCHAR(3)
EXECUTE ('BEGIN PPC.PRUEBA_CHAR (?); END;', @DATA2 OUTPUT) AT [GETESTING]
I am getting this error:
(1 row affected)
Msg 7215, Level 17, State 1, Line 3
Could not execute statement on remote server 'GETESTING'.