I have a PL/SQL procedure in an Oracle database. The procedure has some business logic. Based on the business logic it retrieves a few rows. I also have a very simple SQL Server database table where I want the results populated.
In a simple way, I want to insert a table from a PL/SQL Oracle procedure into SQL Server.
You can use ODBC to create a database link from Oracle to SQL Server. Your DBA can help you create the database link from Oracle to SQL Server. Using the database link you can create a synonym in Oracle for the table you want to reference in PL/SQL and use that in your PL/SQL code (Please note from SQL Server to Oracle it is called a linked server).