CODEWITHSUNDEEP
sql-serverstored-proceduresoracle11g
Angelina
Angelina

Reputation: 2265

Create SQL Server Stored Procedure that will get last_Run_DateTime column from ORACLE table

Is there a way to create stored procedure in sql server that will go to my table in Oracle db and get the last run datetime?

Upvotes: 0

Views: 53

Answers (1)

Angelina
Angelina

Reputation: 2265

I went with Linked Servers approach. This article explained exactly what to do step-by-step.

http://sqlmag.com/sql-server/connecting-sql-server-and-oracle-using-linked-servers

Upvotes: 1

Related Questions