Oracle procedure from SQL Server

Hello,
Can I call Oracle procedure from SQL Server? If it is posible how can i do it?
ThanksYou can either
1. set up a linked server to Oracle and use the 4 part name Ie exec
oraserver...procname (search for linked server in SQL Books) or
2. uas a pass through query( ie
EXEC sp_addlinkedserver 'OracleSvr',
'Oracle 7.3',
'MSDAORA',
'ORCLDB'
GO
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO
Search or OPENQUERY in SQL Books
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"RioDD" <RioDD@.discussions.microsoft.com> wrote in message
news:0880F98B-D2BC-4036-93F3-60EF640C6E6E@.microsoft.com...
> Hello,
> Can I call Oracle procedure from SQL Server? If it is posible how can i do
it?
> Thanks