.NET Stored Procedure: Reading a Text File into an Oracle Table - Deploying the Oracle based .NET CLR stored procedure using Visual Studio.NET
(Page 2 of 5 )
Once you complete all of the steps in the previous section, proceed with the following steps to deploy the .NET CLR based stored procedure using Visual Studio.NET.
- Press Ctrl+Alt+L to open “Solution Explorer.”
- Right click on “Sample1” project and select “Deploy.”
- Skip the welcome screen by clicking on “next.”
- Select the “data connection” you already created (you can even create a new connection by clicking on the “New Connection” button) and click “next.”
- In the next screen, select the “Copy assembly and generate stored procedures” option and click “next” (shown in Fig 2).
- Accept the defaults in the next screen and click “next.”
- Accept the defaults in the next screen and click “next.”
- Select all checkboxes in the “Available methods,” select “External” for security (shown in Fig 3) and click “finish.”
You need to select “External” as part of security, as we are trying to access “something outside” the Oracle database. And thus it is considered to not be “safe.” This is a bit different from what we have seen in my first article.
Next: Testing the Oracle-based .NET CLR stored procedure >>
More .NET Articles
More By Jagadish Chaterjee
/ 10 
