Geeks With Blogs
Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done
Get up and Running with Oracle Express & Visual Studio 2005
 
1.   Install Oracle Express:
 
·         Oracle Database 10g Express Edition (Western European)
·         http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html
 
2.   Install Oracle Tools for .NET (Oracle Data Access Components (ODAC) for Windows ):
 http://www.oracle.com/technology/software/tech/windows/odpnet/install10202.html
3.   In Visual Studio 2005
a.   View -> Oracle Explorer
b.   Right click “Data Connections” -> Add Connection
c.   Data Source Name: XE
d.   Use a specific user name and password
                                             i.      User name:  SYS
                                         ii.      Password:     <password>
                                    iii.      Save password <checked>
e.   (observe new SYS.XE connection)
f.   Expand SYS.XE connection
                                             i.      Expand Schemas
1.   Expand HR
a.   Expand Procedures
b.   Right Click Procedures -> New PL/SQL Proc
 
 

PROCEDURE "HR"."EMPLOYEES_UPDATE_FIRST_NAME"

  (  p_emp_id          Employees.employee_id%type

   , p_NewFirstName        string

   )

IS

BEGIN

  Update Employees set FIRST_NAME = p_NewFirstName

  WHERE employee_id = p_emp_id;

 

END "EMPLOYEES_UPDATE_FIRST_NAME";
c.   Save
 
g.   Right click SYS.XE connection -> Query Window
                                             i.      select * from hr.employees
                                         ii.      call HR.EMPLOYEES_UPDATE_FIRST_NAME(100, 'hazel');
----------------------------------------------------
From: Adnan <adnan_hebibovic@msn.com>
Url: none given
IP: 193.77.6.1
====================================================

You don't need ODP just create solution, add new project, database
project ;)

With Data Explorer create connection to XE :)
Posted on Tuesday, October 10, 2006 11:54 AM Oracle | Back to top


Comments on this post: Get up and Running with Oracle Express & Visual Studio 2005

# re: Get up and Running with Oracle Express & Visual Studio 2005
Requesting Gravatar...
You don't need ODP just create solution, add new project, database project ;)

With Data Explorer create connection to XE :)
Left by Adnan on Sep 07, 2007 2:44 AM

# re: Get up and Running with Oracle Express & Visual Studio 2005
Requesting Gravatar...
On reading your post I was lost in thought for a long time and it occured to me that you are quite right on that. Good article. Thank you.
Left by tim on Jun 14, 2010 4:45 AM

# re: Get up and Running with Oracle Express & Visual Studio 2005
Requesting Gravatar...
Thanks alot for sharing this, was a great post. You don't need ODP just create solution, add new project, database
project ;)

With Data Explorer create connection to XE :)
Left by new york canvas on Jun 15, 2011 7:18 AM

Your comment:
 (will show your gravatar)


Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net