Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 procedure inside the oracle table

Author  Topic 

desikankannan
Posting Yak Master

152 Posts

Posted - 2008-03-17 : 09:17:53
Hi,
we have the senario we want to call oracle table inside the sql stored procedure, it is possible to call oracle table inside the sql stored procedures.

Regards
Kannan.D

Desikankannan

ayamas
Aged Yak Warrior

552 Posts

Posted - 2008-03-17 : 09:22:58
I think you will have to create a linked server & use Openquery to execute the query.You can google for more info on Openquery.
Go to Top of Page

desikankannan
Posting Yak Master

152 Posts

Posted - 2008-03-17 : 09:30:52
Hi,
can you send detail link for this topic i need badly.

Regards
Kannan.d

quote:
Originally posted by ayamas

I think you will have to create a linked server & use Openquery to execute the query.You can google for more info on Openquery.



Desikankannan
Go to Top of Page

ayamas
Aged Yak Warrior

552 Posts

Posted - 2008-03-17 : 09:36:36
Well I found two of them :-

http://msdn2.microsoft.com/en-us/library/ms188427.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2949788&SiteID=1

I think the first one will be more helpfull.
Go to Top of Page
   

- Advertisement -