Call an Oracle Store Procedure in SQL 2000

Hi all,

I am trying to call and execute an Oracle store procedure in SQL 2000 and also insert Paramaters into the Oracle store procedure so it will update an oracle db table.

I've seen very little help on this topic, does anyone hav any examples or help on this ?

Paul.

If you know how to execute a oracle stored procedure from a command prompt, use xp_cmdshell in sql server.|||

Please do the search below for various posts from me on this topic.

http://groups.google.com/groups?as_q=oracle+package&num=20&scoring=r&as_epq=&as_oq=&as_eq=&as_ugroup=microsoft.public.sqlserver.*&as_usubject=&as_uauthors=umachandar&lr=&as_drrb=q&as_qdr=&as_mind=1&as_minm=1&as_miny=1981&as_maxd=12&as_maxm=3&as_maxy=2007&safe=off

The posts contain examples on how to call Oracle SP from SQL Server using linked servers. You need to basically wrap the procedure in a Oracle package with special parameters and call it via OPENQUERY.

|||Very helpful .. thanks :)