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 that the result set of the stored procedures in Server A will be stored in the Server B oracle table.
As I m a newbie in this 2 env, can any one walk me thru how I can do this ?
Many thanks in advance.
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 that the result set of the stored procedures in Server A will be stored in the Server B oracle table.
As I m a newbie in this 2 env, can any one walk me thru how I can do this ?
Many thanks in advance.