DSXchange

Thanks for the prompt responses. However, Sainath's response has confused me. Are you saying that in the case that i mentioned, there would be network bottlenecks even for the stored procedure? When I execute the stored procedure in sqlplus it gets executed in around a hour. So, If I have a dummy ma...

Hi All, We are calling a Oracle Stored Procedure in after-sql in our Target OCI 9i Stage. This Stored procedure basically selects records from our source database(oracle 9i) using a database link, does some complex transformations and inserts into target database(oracle 9i). The source and target da...