CODEWITHSUNDEEP
sqlsql-serversql-server-2005oracle-databaset-sql
Yves
Yves

Reputation: 12507

Executing an Oracle Stored Procedure from SQL Server 2005

how do we execute an Oracle Stored Procedure from SQL Server 2005? As part of a SQL Server scripts we need to execute an Oracle 10g Stored Procedure and download data to SQL Server 2005

Upvotes: 3

Views: 1854

Answers (1)

John Gietzen
John Gietzen

Reputation: 49544

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

Upvotes: 2

Related Questions