Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Run MS SQL stored procedure from Oracle 10g and store result in Oracle 10g table
Thanks for all your suggestions. As instructed by my manager, I'm not allowed to make changes to the SQL server A and nothing can be done on the SQL server A, NO SSIS and no customized Stored Proc...etc, I am only allowed to run the Stored Proc in SQL server A (sorry not mentioned this part in...- mytechreg
- Post #10
- Forum: Oracle: All versions
-
Run MS SQL stored procedure from Oracle 10g and store result in Oracle 10g table
Thanks for all your suggestions. My original idea is what Bill mentioned, "run the sql server stored procedure in sql server and directly write into the oracle table", but i have no idea that what has to be configured in both server A (SQL server) and server B (Oracle) before that can be done...- mytechreg
- Post #5
- Forum: Oracle: All versions
-
Run MS SQL stored procedure from Oracle 10g and store result in Oracle 10g table
Hi, My case is : I have an application running on MS SQL 2008 R2 in Server A, which there are a couple of stored procedures in there. I have also a Oracle 10g in Server B. Now that, I created a table in the Oracle 10g DB in Server B and would like to run the stored procedures in Server A, so...- mytechreg
- Thread
- Replies: 10
- Forum: Oracle: All versions
