Click here to Skip to main content
15,794,593 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Dear frnds,
             I have one doubt about how to call oracle stored procedure into SQL stored procedure?
Is there anybody knows this answer kindly support with me and give me an example..

Thanks and Regards,
Parthiban K
George Jonsson 10-Jul-14 4:49am    
Do you mean that you want to call a stored procedure in an Oracle database directly from a stored procedure in SQL server?

1 solution

Create Oracle Linked Server[^], then call Oracle SP as is shown below:
EXEC('CALL usp_myProcedure(''argument1'')') AT MyOracleServer;

Linked Servers (Database Engine)[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900