executing (from sql server 2000) procedures from oracle package through linkserv

Hello,
I deaply need to know how to execute procedures from package in oracle, from sqlserver 2000 using linkserver.
Thank you very much,
Victor
DBAJust ot clarify: are you trying to execute an Oracle Stored procedure using SQL Server with the Oracle server configured as a Linked Server?

Or are you trying to execute a SQL stored procedure from Oracle?

Sorry, I wasn't entirely clear on your intent from your question.

Regards,

hmscott|||Well .. you cant directly execute a stored procedure in ORACLE from SQL Server

If you really need to do that .. here is a get around

1. Create a table in Oracle .. lets say execProc
2. On update of the table make a trigger in oracle to execute a stored procedure.
3. Update the oracle table through linked server query