All geek questions in one place

Executing an Oracle stored procedure from SQL Server 2005

How do we execute an Oracle stored procedure from SQL Server 2005? As part of SQL Server scripting, we need to execute the Oracle 10g stored procedure and upload the data to SQL Server 2005

+3
source share
1 answer

I believe that you can still use SELECT * FROM OPENQUERY(ORA_SERVER, 'EXECUTE sp;')to accomplish this.

+2
source

Source: https://habr.com/ru/post/1721536/

More articles:


All Articles