Index

A B C D E F G H I L M N O P Q R S T U V W X Z

A

account

unlocking, 5.1, 7.3

Add Connection window, 5.1, 7.3, 7.5

Add Method window, 6.4, 6.4

add reference, 3.2

Add Reference dialog, 3.2

Add() method, 4.4

adding

reference, 3.2

adding reference, 3.2

alias

database, 5.1

ALTER TABLE, 5.4, 5.4

application

result, 4.4

run, 3.6, 3.7, 3.7, 4.3, 4.5, 4.6, 5.6, 5.7, 6.5

apply filters, 5.1, 7.3

B

bind variable, 4.4

definition, 4.4

identifier, 4.4, 4.4

name, 4.4, 4.4

position, 4.4, 4.4

update, 4.4

BindByName property, 4.4

binding data, 4.6, 4.6

build

deploy solution, 7.5

success, 7.4

Build menu, 7.4, 7.5

build solution, 7.4

building connection, 3.5, 3.5

button, 3.4, 4.6

disable, 3.5, 3.6

C

HRVisual Studio Projects directory, 4.1

C# statement

using, 3.3

Case statement, 3.7

class variable, 4.6

Click event, 3.4

click event, 4.6

client globalization settings, 8.5.1

close connection, 3.8

CLR, 1.1

Code view, 3.3

code view, 5.6, 5.7, 6.5

column

add, 5.2

data type, 5.2

name, 5.2

property, 5.2

size, 5.2

command

database query, 4.2, 4.2

definition, 4.2

query, 4.2, 4.2

using, 4.2

CommandType property, 4.2

Common Language Runtime

definition, 1.1

Common Language Runtime Host for Oracle Database, 1.4

Common Language Runtime Service

starting, 7.1

Configure Your Connection window, 7.5

connect, 5.1

connect project, 3.2

connect_Click() method, 3.4, 3.5, 4.6, 4.6, 6.5

connection

add, 5.1, 7.3, 7.5

building, 3.5, 3.5

close, 3.8

creating, 7.3

data, 5.1, 5.6, 7.3

data source name, 5.1, 5.1, 7.3, 7.3, 7.5

detail, 5.1

details, 7.3

dispose, 4.6

hr. (Local Database), 5.6

hr.(Local Database), 5.1, 7.3

hr.(LocalDatabase), 7.6

name, 5.1, 7.3

new, 7.3, 7.5

opening, 3.5, 3.5

password, 5.1, 5.1, 7.3, 7.5

role, 5.1

saving password, 5.6

specific user name and password, 5.1

SYSDBA, 7.5

table, 5.6

test, 5.1, 7.3, 7.5

test failure, 5.1, 7.3

test success, 5.1

user name, 5.1, 5.1, 7.3, 7.3

user name and password, 7.3

username, 7.5

connection element, 3.4

constraint

add, 5.4, 5.4

constraint properties, 5.4, 5.4

Constraints tab, 5.4

copy project, 4.1

CREATE TABLE, 5.2

cultural convention, 8.1

cultural conventions, 8

culture conventions, 8.5

Culture ID parameter, 8.4

Culture parameter, 8.4

CultureInfo, 8.2

culture-sensitive data, 8.5

CurrentCulture parameter, 8.5.3

D

data

navigate, 5.6

sort, 5.6

Data Access for .NET Classes, 1.4

data connection, 5.1, 5.6

data entry element, 3.4

Data Grid, 4.6

data grid, 4.6, 4.7, 6.5

data provider, 3.2

Oracle Data Provider for .NET, 1.2

data source name, 5.1, 7.3

database error message, 3.7, 3.7

DataGrid, 4.5

DataGrid class, 5.6, 5.6, 5.6, 5.6, 6.5

filling, 5.6, 5.6

properties, 5.6

DataReader class, 4.5, 4.5, 4.5

DataSet class, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6, 4.6

definition, 4.6

generate, 5.6

updating, 8.5.2, 8.5.2

DataSource parameter, 5.6

date

format, 8.3.1

date format, 8.3.1

change, 8.5.2, 8.5.2

long, 8.3.1

settings, 8.3.1

short, 8.3.1

standard, 8.3.1

Debug menu, 3.6

default role, 5.1, 7.3

DELETE statement, 4.4

deleting data, 4.7

design property, 4.3

Design view, 3.4, 3.4, 4.3, 4.6, 5.2, 5.2, 5.3, 5.6, 6.4, 6.4, 6.4

Design window, 5.6, 5.6

Designer window, 5.6

dialog

New Project, 7.2, 7.2

new project, 3.1, 3.1

Direction property, 4.4, 4.4, 4.4

disable button, 3.5, 3.6

display schema, 5.1, 7.3

Dispose() method, 3.7, 3.7, 3.8

E

Easy Connect

syntax, 3.5

edit package body, 6.4

error handling, 3.7

Try-Catch-Finally, 3.7, 3.7

type

exceptions with ODP.NET, 3.7

ODP.NET, 3.7

Oracle, 3.7

error message, 8.3.4

Error property, 3.7

event

click, 3.4

Events icon, 3.4

Exception class, 3.7

ExecuteReader() method, 4.3

EZ Connect Adapter, 3.5

F

FCL, 1.1

File menu, 3.1, 3.3, 7.2

finally block, 4.6

foreign key, 5.4, 5.4

Framework Class Libraries

definition, 1.1

G

GetClientInfo() method, 8.5.1

GETCURSORS method, 6.4

GETCURSORS procedure, 6.4

GETDEPARTMENTNO procedure, 7.6

getDepartmentno(), 7.4, 7.4

getDepartmentno() method, 7.4, 7.5

GetSessionInfo() method, 8.5.2

GetThreadInfo() method, 8.5.3

global application

deployment, 8

development, 8

.NET framework, 8.2

planning, 8.2

global applications

introduction, 8.1

globalization

definition, 8.2

globalization session information, 8.5.2, 8.5.2

globalization support, 8.5

client, 8.5

ODP for .NET, 8.5

globalization support features, 8

H

handling errors, 3.7

host, 3.5

HR_Connect_CS folder, 4.1, 4.1

HR_Connect_CS project, 3.1, 4.6

HR_Connect_CS solution, 4.1, 4.1

HR_Connect_VB folder, 4.1

HR_Connect_VB project, 3.1, 4.6

HR_Connect_VB solution, 4.1

HR_DATA package, 6.4, 6.4, 6.4

HR_DataSet_ODP_CS project, 4.6, 6.4

HR_DataSet_ODP_VB project, 4.6

HR_DeployStored_CS project, 7.2, 7.5

HR_DeployStored_VB project, 7.2, 7.5

HR_Globalization_CS project, 8.5.2

HR_Globalization_VB project, 8.5.2

HR_ODP_CS folder, 4.1, 4.1

HR_ODP_CS solution, 4.1, 4.1, 4.1

HR_ODP_VB folder, 4.1

HR_ODP_VB solution, 4.1, 4.1, 4.1

HR_ODT_CS project, 5.1

HR_ODT_VB project, 5.1

HR_StoredProcedure_CS project, 6.4

HR_StoredProcedure_VB project, 6.4

I

Imports statement, 3.3

index

add, 5.3

add key, 5.3

creating, 5.3

key, 5.3

name, 5.3

property, 5.3

Indexes tab, 5.3

initial programmatic statement, 3.3

C#, 3.3

VB, 3.3

InitializeComponent() method, 5.6

INSERT statement, 4.4

inserting data, 4.7

InstallShield wizard, 2.2

L

Label, 3.4

label, 4.3

language

sorting rules, 8.3

lightning icon, 3.4

linguistic sort, 8.3.3

list box, 4.3

ListBox, 4.3, 4.5

literal quotation marks, 4.4

local user convention, 8.3

locale

definition, 8.1

synchronizing, 8.4

locale awareness, 8

locale characteristics

definition, 8.1

localization

definition, 8.2

resources, 8.2

LTER TABLE, 5.4

M

memory address, 6.3

memory location, 6.3

Build, 7.4

build, 7.5

Debug, 3.6

File, 3.3, 7.2

file, 3.1

Project, 3.2

View, 3.2, 3.3, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.6, 4.6, 5.1

method

add, 6.4

Add(), 4.4

connect_Click(), 3.5, 6.5

detail, 7.5

Dispose(), 3.7, 3.7, 3.8

GETCURSORS, 6.4

getDepartmentno(), 7.5

name, 6.4

Open(), 3.5, 3.5

parameter, 6.4

save_Click(), 5.7

type, 6.4

method parameter

add, 6.4

binding, 6.5

data type, 6.4

definition, 6.5

detail, 6.4

direction, 6.4

name, 6.4

Microsoft Development Environment window, 5.6

Microsoft internationalization

URL, 8

Microsoft .NET Framework

definition, 1.1

N

Name property, 3.4, 3.4, 4.6

name property, 4.3

navigate

data, 5.6

records, 5.6

.NET assembly, 1.4

.NET framework, 8.2

.NET languages, 1.3

.NET stored functions and procedures

creating, 7.4

deploying, 7.5

running, 7.6

.NET Stored Procedures, 2.1

.NET stored procedures, 1.3

deployment, 7

.NET Types, 8.5.3

New Package window, 6.4, 6.4, 6.4

new project, 3.1

New Project dialog, 3.1, 3.1, 7.2

NLS error messages setting, 8.3.4

NLS number format

settings, 8.3.2

NLS Registry, 8.5.2

NLS sort order, 8.3.3

NLS_LANG, 8.5.1

NLS_LANG parameter, 8.5, 8.5

NLS_LANGUAGE parameter, 8.3.1, 8.3.1, 8.3.4, 8.3.4, 8.3.4, 8.4, 8.4

common, 8.4

NLS_SORT parameter, 8.3.3, 8.3.3

NLS_TERRITORY parameter, 8.3.1, 8.3.1, 8.3.2, 8.3.2, 8.4, 8.4

common, 8.4

number format, 8.3.2

O

ODBC, 2.1

ODP.NET

definition, 1.2

globalization, 8

ODP.NET Types, 8.5.3, 8.5.3

OLE DB, 2.1

OPD.NET

using, 5

Open() method, 3.5, 3.5, 8.5

opening connection, 3.5, 3.5

Oracle Application Express, 2.1, 7.5

Oracle Data Provider for .NET, 2.1, 3.2

definition, 1.2

using, 4

Oracle Database Extensions

features

Common Language Runtime Host for Oracle Database, 1.4

Data Access for .NET Classes through Oracle Data Provider for .NET, 1.4

Oracle Deployment Wizard for .NET, 1.4

Oracle Deployment Wizard for Visual Studio .NET, 1.4

Oracle Database XE, 2.1

client, 2.1

server, 2.1

Oracle date format, 8.3.1

Oracle Deployment Wizard, 7.5, 7.5

Oracle Deployment Wizard for Visual Studio .NET, 1.4

Oracle Developer Tools

definition, 1.3

features

designer, 1.3

drag and drop, 1.3

dynamic help, 1.3

Oracle Data Window, 1.3

Oracle Explorer, 1.3

Oracle Query Window, 1.3

PL/SQL editor, 1.3

Solution Explorer, 3.2

wizard, 1.3

installation, 2.2

testing installation, 2.3

Oracle Developer Tools for Visual Studio .NET

using, 5

Oracle error message, 8.3.4

Oracle Explorer, 5.1, 5.1, 5.2, 5.4, 5.5, 5.6, 6.4, 6.4, 6.4, 7.3, 7.3, 7.6

Oracle Globalization Registry, 8.5.2

Oracle globalization setting, 8.5.1

Oracle globalization settings, 8.5.1

Oracle linguistic sort, 8.3.3

Oracle number format, 8.3.2

Oracle project

creating, 7.2

OracleCommand

using stored procedure, 6.5, 6.5

OracleCommand class, 4.2, 4.2, 4.3, 4.4, 4.4

OracleConnection, 3.5

OracleConnection class, 3.5, 3.5, 5.6, 8.5, 8.5.2

GetSessionInfo() method, 8.5.2

Open() method, 8.5

Oracle.DataAccess, 3.2

OracleDataAccess.dll, 3.2, 3.2

OracleDataAdapter class, 5.6

OracleDataReader class, 4.3, 4.3, 4.3, 4.5, 4.6

OracleDbType property, 4.4, 4.4

OracleError class, 3.7, 3.7

OracleErrorCollection class, 3.7

OracleException class, 3.7, 3.7, 3.7

OracleGlobalization, 8.5.1

OracleGlobalization class, 8.5.2, 8.5.3, 8.5.3

GetClientInfo() method, 8.5.1

GetThreadInfo() method, 8.5.3

SetThreadInfo() method, 8.5.3

OracleGlobalization.GetClientInfo(), 8.5.1

OracleGlobalization.GetClientInfo() method, 8.5.1

OracleParameter class, 4.4, 4.4, 6.5, 6.5

OracleParameterCollection class, 4.4, 4.4

OracleRefCursor class, 6.3

OracleServiceXE, 3.7, 3.7

OracleXEClrAgent, 7.1, 7.1

OracleXEClrAgent service, 7.1, 7.1

order

ascending, 5.6

descending, 5.6

Output window, 6.4, 7.4

P

package

edit body, 6.4

HR_DATA, 6.4, 6.4, 6.4, 6.4

name, 6.4

new, 6.4

save, 6.4

package body, 6.1

PACKAGE BODY type, 6.1

package interface, 6.1

package specification, 6.1

PACKAGE type, 6.1

parameter, 6.4

parameter detail, 6.4, 6.4

ParameterName property, 4.4

password, 3.5

save, 5.1, 5.6

saving, 7.3

set, 7.5

PasswordChar property, 3.4

PL/SQL package

body, 6.1

definition, 6.1

interface, 6.1

specification, 6.1

PL/SQL package bodies, 6.1

PL/SQL packages

introduction, 6.1

PL/SQL stored procedure

definition, 6.2

in ODP.NET, 6.5

introduction, 6.2

ref cursor, 6.4

PL/SQL stored procedures, 6

port, 3.5

preview SQL, 5.2, 5.3, 6.4

Preview SQL window, 5.2, 5.3, 5.3, 5.4, 5.4, 6.4

primary key, 5.4

column, 5.4

procedure

GETCURSORS, 6.4

GETDEPARTMENTNO, 7.6

run, 7.6

value, 6.4, 6.4, 6.4

project

add reference, 3.2

connect, 3.2

connection, 3.2

copy, 4.1

HR_Connect_CS, 3.1, 4.6

HR_Connect_VB, 3.1, 4.6

HR_DataSet_ODP_CS, 4.6, 6.4

HR_DataSet_ODP_VB, 4.6

HR_DeployStored_CS, 7.2, 7.5

HR_DeployStored_VB, 7.2, 7.5

HR_ODT_CS, 5.1

HR_ODT_VB, 5.1

HR_StoredProcedure_CS, 6.4

HR_StoredProcedure_VB, 6.4

location, 3.1, 7.2

name, 3.1, 7.2, 7.2

new, 3.1, 3.1, 7.2

solution, 3.1

template, 3.1, 7.2

type, 3.1, 3.1, 7.2

Visual Basic, 3.1, 7.2

Visual C#, 3.1, 7.2

Project menu, 3.2

propert

text, 4.6

properties

data, 5.6

Properties window, 3.4, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.3, 4.3, 4.6, 4.6, 4.6, 5.6, 5.6

property, 3.4, 3.4, 3.4, 4.6, 4.6

appearance, 3.4, 4.6

behavior, 3.4

BindByName, 4.4

design, 3.4, 3.4, 4.3, 4.6, 4.6

Direction, 4.4, 4.4, 4.4

Error, 3.7

Name, 3.4, 3.4, 4.6

name, 4.3

OracleDBType, 4.4

OracleDbType, 4.4

ParameterName, 4.4

PasswordChar, 3.4

Size, 4.4, 4.4, 4.4

Text, 3.4, 3.4, 3.4, 4.3

Value, 4.4, 4.4

Q

query performance, 4.4

query work area

definition, 6.3

R

record, 4.7, 5.5

add, 5.5

delete, 4.7

navigate, 5.6

sort, 5.6

REF cursor, 6

ref cursor

accessibility, 6.3

assigning, 6.4

database round trip, 6.3

database update, 6.3

definition, 6.3

introduction, 6.3

PL/SQL datatype, 6.3

PL/SQL stored procedure, 6.4

reading, 6.3

read-only, 6.3

serial, 6.3

reference

add, 3.2

adding, 3.2, 3.2

folder, 3.2

list, 3.2

rename solution, 4.1

resources

deploying, 8.2

localization, 8.2

packaging, 8.2

result set, 6.3

retrieving data

accessor type methods, 4.3

bind variable, 4.4, 4.4, 4.4

looping, 4.5, 4.5

multiple column, 4.5

multiple row, 4.5

multiple values, 4.5

native data type, 4.3

native Oracle data type, 4.3

simple query, 4.3

value, 4.3, 4.3

zero-based ordinal, 4.3

role, 7.3

user, 5.1

user default, 5.1

row, 5.5

row set, 6.3

run

application, 4.5, 5.7

Run application, 3.7

run application, 3.6, 3.7, 4.3, 4.6

Run Function window, 7.6

Run Procedure window, 6.4

running an application, 5.6

S

Sample Data, 2.1

sample data, 2.1

Sample Schema, 2.1

Save button, 5.7

Save icon, 3.3

save_Click() method, 4.6, 4.6, 5.7, 5.7, 5.7

schema

content, 5.1

display, 5.1, 7.3

schema object, 1.3, 7.3

SELECT statement, 4.4, 4.4

bind variable, 4.4

simple, 4.4

service_name, 3.5

services, 7.1

session globalization parameter, 8.5.2

session globalization setting, 8.5.2

SetThreadInfo() method, 8.5.3

Setup file, 2.2

Setup icon, 2.2

simple query, 4.3

Size property, 4.4, 4.4, 4.4

software download, 2.2

solution, 3.1

deploy, 7.5

Solution 'HR_Connect_CS', 4.1

Solution 'HR_Connect_VB', 4.1

Solution Explorer, 3.2, 3.2, 3.2, 3.2, 3.2, 3.4, 4.1, 4.1

sort

data, 5.6

records, 5.6

Specify an assembly and library name window, 7.5

Specify copy options window, 7.5

Specify methods and security details window, 7.5

Specify your deployment option window, 7.5

SQL

preview, 5.2

SQL injection attack, 4.4

SQL preview, 5.3

SQL query, 4.2

SQL statement, 4.4, 4.4, 4.4, 4.4, 5.3

SQL statement string, 4.2, 4.2

SQLPlus, 8.3.1

Start Database window, 3.7

statement

Case, 3.7

DELETE, 4.4

Imports, 3.3

INSERT, 4.4

memory, 4.4

optimizing, 4.4

parsing, 4.4

reusing, 4.4

UPDATE, 4.4

using, 3.3

stored procedure, 4.4

definition, 6.2

run, 6.4

stored procedure declaration, 4.4

Summary window

window

Summary, 7.5

System.Globalization, 8.2

System.Resources, 8.2

System.Threading.Thread.CurrentThread.CurrentCulture parameter, 8.5.3

T

table

add constraint, 5.4

add data, 5.5

constraint, 5.4, 5.4

add, 5.4, 5.4, 5.4

association, 5.4

local column, 5.4

primary key, 5.4

referenced column, 5.4

constraint name, 5.4

constraint properties, 5.4, 5.4

constraint type, 5.4

creating, 5.2

data, 5.5

grid, 5.5

name, 5.2

new, 5.2

new relational, 5.2

query, 5.6

record, 5.5

relational, 5.2

retrieve data, 5.5

row, 5.5

simple query, 5.6

SQL form, 5.2

table design view, 5.3, 5.4

table design window, 5.2

table grid, 5.5

test

result, 7.5

test result window, 7.5

Text Box, 3.4

Text property, 3.4, 3.4, 3.4, 4.3, 4.6

thread-based globalization setting, 8.5.3

Toolbox, 3.4, 3.4, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.3, 4.3, 4.6, 4.6, 4.6, 4.6, 4.6, 5.6

try code block, 4.2, 4.6, 6.5

Try-Catch-Finally, 3.7, 3.7

Try-Catch-Finally error handling, 3.7, 3.7

type of project, 3.1

U

unlocking account, 5.1, 7.3

unlocking user account, 2.3

Oracle XE Database interface, 2.3, 7.5

update event, 5.7

UPDATE statement, 4.4

updating data, 4.7

bind variable, 4.4

user

default role, 7.3

id, 3.5

locale settings, 8.4

role, 5.1, 7.3

user's locale, 8.1

user_source view, 6.1

using statement, 3.3

V

Value property, 4.4, 4.4

variable declaration, 4.6

VB statement

Imports, 3.3

view

Code, 3.3

code, 5.6, 5.7, 6.5

Design, 3.4, 3.4, 4.3, 4.6, 5.2, 5.2, 5.3, 5.6, 6.4, 6.4, 6.4

table design, 5.3, 5.4

user_source, 6.1

View menu, 3.2, 3.3, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.6, 4.6, 5.1

Visual Basic, 3.1, 7.2

Visual C#, 3.1, 7.2

Visual Studio .NET 2003, 2.1

W

warning, 3.7

WHERE statement clause, 4.4

window

Add Connection, 5.1, 7.3, 7.5

Add Method, 6.4, 6.4

Design, 5.6, 5.6

Designer, 5.6

Microsoft Development Environment, 5.6

New Package, 6.4, 6.4, 6.4

Output, 6.4, 7.4

Preview SQL, 5.2, 5.3, 5.3, 5.4, 5.4, 6.4

Properties, 3.4, 3.4, 3.4, 3.4, 3.4, 4.3, 4.3, 4.3, 4.6, 5.6, 5.6

Run Function, 7.6

Run Procedure, 6.4

Specify an assembly and library name, 7.5

Specify copy options, 7.5

Specify methods and security details, 7.5

Specify your deployment option, 7.5

table design, 5.2

test result, 7.5

Windows Explorer, 4.1

Windows forms, 3.4, 3.4, 3.4, 4.3, 4.3, 4.5, 4.6, 4.6, 5.6

Windows Registry, 8.5, 8.5.1

X

XE Common Language Runtime agent, 7.1

Z

zero-based ordinal, 4.3