Why dont you use SSIS for loading the data between servers?

Try to create a primary key/unique key on your table variable, and it is always better to go as a stored proc using temp tables and while loop instead...

please go through this link.this may help you out.

http://stackoverflow.com/questions/1589466/sql-server-execute-stored-procedure-with-output-parameter

http://stackoverflow.com/questions/1248244/sql-server-output-parameter-issue

Please check the connection strings for connecting to the oracle database.

datasource should be like SERVERNAME/DATABASENAME in oracle and your schema should have access to that database.