• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

How To Execute An Oracle Stored Procedure From SQL Server Using Linkedserver?

Greetings,

Can someone provide step by step instructions on how to execute an Oracle stored procedure from SQL Server using SQL Server linkedserver?
0
Omega002
Asked:
Omega002
1 Solution
 
OP_ZaharinCommented:
SELECT * FROM OPENQUERY(OraDbAlias, 'EXECUTE storedprocedurename;')

- here is the documentation:
http://msdn.microsoft.com/en-us/library/ms188427.aspx
0
 
Aaron ShiloChief Database ArchitectCommented:
hi

in addition to OP_Zaharin make sure that the linked server properites are set to true under RPC
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now