.NET CLR stored procedures within Oracle database: Another breaking revolution - Testing an Oracle based .NET CLR stored procedure using Visual Studio.NET
(Page 4 of 5 )
Once you click on “finish” button (from the previous section), you should be able to see the output window of Visual studio.NET as something like the following figure 11.
To execute the .NET CLR stored procedure from within Visual Studio.NET, open “Oracle Explorer” from the “View” menu, open “procedures” of “scott” schema and right click on “incrementsalary” as shown in Figure 12.
In the “Run Procedure” dialog, provide value for “empno” as 7839 and “incrementvalue” as 500 (as shown in Figure 13) and click OK.
Once it is successfully executed, it should display something like the following Figure 14.
Now you can check your “emp” table in the database, and “KING” gets his salary incremented from 5000 to 5500!
Next: Testing an Oracle based .NET CLR stored procedure using “iSQL*Plus” >>
More .NET Articles
More By Jagadish Chaterjee
