Accessing Oracle database from SQL Server stored procedure?

Firstly on your SQL Server server you will need to install Oracle Client Tools, the reason behind this is any machine that wants access to a Oracle Database will need the necessary Oracle Client Tools installed to access it.

Up vote 3 down vote favorite 1 share g+ share fb share tw.

I was wondering if someone could give me some pointers on how to connect to an Oracle Database from stored procedure in SQL Server. Sql-server oracle tsql stored-procedures link|improve this question edited Jan 28 at 12:19marc_s176k14142284 asked Jan 28 at 11:41Nickz2,058218 94% accept rate.

3 One option is a linked server to oracle – Andomar Jan 28 at 11:45.

Firstly on your SQL Server server you will need to install Oracle Client Tools, the reason behind this is any machine that wants access to a Oracle Database will need the necessary Oracle Client Tools installed to access it. Secondly you will need to configure the file "tnsnames. Ora" that is installed with the above configured to point to the required Oracle Server/Database that you want to connect to.

Now you will need to create a Linked Server from your SQL Server management studio for that server to the oracle server. Then in your stored procedure you have to follow the rule of: SERVER_NAME.DATABASE.OWNER. OBJECT in order of accessing thing on the oracle database, but keep in mind this is SQL Server syntax and there might be some minor twiking needed.

This is a rough outline and I hope it has set you on your way.

2 thankyou, that's exactly what I'm affer. – Nickz Jan 28 at 11:58.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.