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 :)