List of Examples

1-1 Creating and Specifying Access to a Table

1-2 Creating an Object Table

1-3 Inserting Data through Input Bind Variables

1-4 Inserting Objects into the Oracle Database

1-5 Using the Simple SELECT Statement

1-6 Using the SELECT Statement with Input Variables

1-7 Using PL/SQL to Obtain an Output Variable

1-8 Using PL/SQL to Partial Records into Placeholders

1-9 Using SQL to Extract Partial Records

2-1 How to Determine the Major Client Version and set Performance Features

2-2 Installing Instant Client Light (English) through Oracle Universal Installer

3-1 Usage Scenario for a StatelessConnectionPool

3-2 How to Create and Use a Homogeneous Stateless Connection Pool

3-3 How to Create and Use a Heterogeneous Stateless Connection Pool

3-4 How to Bind Data in a Streaming Mode

3-5 How to Fetch Data in a Streaming Mode Using PL/SQL

3-6 How to Read and Write with Multiple Streams

3-7 How to Fetch Data in Streaming Mode Using ResultSet

3-8 Statement Caching without Connection Pooling

3-9 Statement Caching with Connection Pooling

4-1 Creating Standalone Objects

4-2 Creating Embedded Objects

4-3 Creating a Persistent Object

4-4 Creating a Transient Object

4-5 OTT Support Inheritance

4-6 Listing of demo2.sql for a Sample OCCI Application

4-7 Listing of demo2.typ for a Sample OCCI Application

4-8 Listing of OTT Command that Generates Files for a Sample OCCI Application

4-9 Listing of mappings.h for a Sample OCCI Application

4-10 Listing of mappings.cpp for a Sample OCCI Application

4-11 Listing of demo2.h for a Sample OCCI Application

4-12 Listing of demo2.cpp for a Sample OCCI Application

4-13 Listing of myDemo.h for a Sample OCCI Application

4-14 Listing for myDemo.cpp for a Sample OCCI Application

4-15 Listing of main.cpp for a Sample OCCI Application

5-1 Definition of the BDOUBLE Datatype

5-2 Definition of the BFLOAT Datatype

6-1 How to Obtain Metadata About Attributes of a Simple Database Table

6-2 How to Obtain Metadata from a Column Containing User-Defined Types

6-3 How to Obtain Object Oetadata from a Reference

6-4 How to Obtain Metadata About a Select List from a ResultSet Object

7-1 How to Use the OTT Utility

7-2 Object Creation Statements of the OTT Utility

7-3 How to Invoke the OTT Utility to Generate C++ Classes

7-4 How to use the SCHEMA_NAMES Parameter in OTT Utility

7-5 How to Define a Schema for Unicode Support in OTT

7-6 How to Use UNICODE=ALL Parameter in OTT

7-7 How to Use UNICODE=ONLYCHAR Parameter in OTT

7-8 How to Create a User Defined INTYPE File Using the OTT Utility

7-9 Listing of ott95a.h

7-10 Listing of ott95b.h

7-11 How to Represent Object Attributes Using the OTT Utility

7-12 How to Map Object Datatypes Using the OTT Utility

7-13 OUTTYPE File Generated by the OTT Utility

7-14 How to Generate C++ Classes Using the OTT Utility

7-15 How to Extend C++ Classes Using the OTT Utility

7-16 How to Add User Code to a Header File Using OTT Utility

7-17 How to Add User Code to the Source File Using the OTT Utility

8-1 How to Use Globalization and Unicode Support

8-2 Using wstring Datatype

8-3 Binding UTF8 Data Using the string Datatype

8-4 Binding UTF16 Data Using the UString Datatype

8-5 Using CLOB and NCLOB Datatypes

9-1 Creating an Agent

9-2 Setting the Agent on the Consumer

9-3 Creating an AnyData Message with a String Payload

9-4 Determining the Type of the Payload in an AnyData Message

9-5 Creating an User-defined Payload

9-6 Specifying the Correlation identifier

9-7 Specifying the Sender identifier

9-8 Specifying the Delay and Expiration times of the message

9-9 Specifying message recipients

9-10 Specifying the Priority of a Message

9-11 Creating a Producer, Setting Visibility, and Enqueuing the Message

9-12 Creating a Consumer, Naming the Consumer, and Receiving a Message

9-13 Receiving a Message

9-14 Specifying dequeuing options

9-15 Listening for messages

9-16 How to Register for Notifications; Direct Registration

9-17 How to Use Open Registration with LDAP

10-1 How to Use Transaction Managers with XA

11-1 How to use Array Fetch with a ResultSet

11-2 How to Modify Rows Iteratively and Handle Errors

12-1 Converting From an SQL Pre-Defined Type To AnyData Type

12-2 Creating an SQL Pre-Defined Type From AnyData Type

12-3 Converting From a User-Defined Type To AnyData Type

12-4 Converting From a User-Defined Type To AnyData Type

12-5 How to Get a Date from Database and Use it in Standalone Calculations

12-6 How to Create, Assign Values, and Use an Empty IntervalDS Object through Direct Assignment

12-7 How to Create, Assign Values, and Use an Empty IntervalDS Object through fromText() and toText() Methods

12-8 How to Create, Assign Values, and Use an Empty IntervalYM Object through Direct Assignment

12-9 How to Create, Assign Values, and Use an IntervalYM Object through ResultSet and toText() method

12-10 How to Retrieve and Use a Number Obect

12-11 Using Default Timestamp Constructor

12-12 Using fromText() method to Initialize a NULL Timestamp Instance

12-13 Comparing Timestamps Stored in the Database