.NET CLR stored procedures within Oracle database: Another breaking revolution - Connecting to Oracle 10g (Release 2) from Visual Studio.NET using Oracle Explorer

Before proceeding further with this article, make sure that all of the following software is properly installed and configured on your system:

• Oracle database 10g Release 2 database server (or Oracle v10.2 client connected to another Oracle 10.2 database server) available at http://www.oracle.com/technology/software/products/
  database/oracle10g/index.html
• Microsoft Visual Studio.NET 2003 Enterprise Architect
• Oracle Developer tools for Visual Studio.NET 10.2.x.x (freely downloadable at http://www.oracle.com/technology/software/tech/dotnet/odt_index.html)

Let us go through the following steps to connect to Oracle 10g using Visual Studio.NET 2003:

• Open Visual Studio.NET 2003 IDE
• Go to menu View -> Oracle Explorer as shown in Figure 1
  
• Within the Oracle Explorer, right click on Data Connections -> Add Connection (Fig2)
  
• Within the “Add Connection” window, provide the details of “Data Source”, “User Name” and “Password” (as shown in Figure 3).  You can test the details by clicking on “Test Connection” button.
  
• Once you click “OK”, Oracle Explorer gets updated as shown in Figure 4.
  

“Data Source” will be generally the global SID or “Local net Service Name” you configured during Oracle server/client installation.  For this demonstration, I am using the “scott” schema (sample schema provided by Oracle) with the password “tiger”.

Once you get connected, you can play with all the items existing within the “Oracle Explorer” along with creating tables, inserting, modifying, deleting, dropping, designing relations, stored procedures (using PL/SQL), and so on. Enjoy playing with it.

Next: Developing an Oracle based .NET CLR stored procedure using Visual Studio.NET >>
 

More .NET Articles
More By Jagadish Chaterjee

Comments On: .NET CLR stored procedures within Oracle database: Another breaking revolution

· Hello....Not only SQL Server 2005, you can also use Oracle to deploy your .NET CLR...   >>> Post your comment now!