List of Tables

1-1 Obsolescent OCI Functions
1-2 OCI Functions Not Supported
1-3 OCI Instant Client Shared Libraries
1-4 OCI Instant Client Light Shared Libraries
2-1 OCI Handle Types
2-2 Descriptor Types
2-3 OCI Return Codes
2-4 Return and Error Codes
2-5 Oracle Reserved Namespaces
3-1 Internal Oracle Database Data Types
3-2 External Data Types and Codes
3-3 VARNUM Examples
3-4 Format of the DATE Data Type
3-5 Data Conversions
3-6 Data Conversions for LOBs
3-7 Data Conversion for Datetime and Interval Types
3-8 Data Conversion for External Data Types to Internal Numeric Data Types
3-9 Data Conversions for Internal to External Numeric Data Types
3-10 OCITypeCode Values and Data Types
3-11 OCI_TYPECODE to SQLT Mappings
4-1 OCI_ATTR_STMT_TYPE Values and Statement Types
5-1 Information Summary for Bind Types
6-1 Attributes of All Parameters
6-2 Attributes of Tables or Views
6-3 Attributes Specific to Tables
6-4 Attributes of Procedures or Functions
6-5 Attributes Specific to Package Subprograms
6-6 Attributes of Packages
6-7 Attributes of Types
6-8 Attributes of Type Attributes
6-9 Attributes of Type Methods
6-10 Attributes of Collection Types
6-11 Attributes of Synonyms
6-12 Attributes of Sequences
6-13 Attributes of Columns of Tables or Views
6-14 Attributes of Arguments and Results
6-15 List Attributes
6-16 Attributes Specific to Schemas
6-17 Attributes Specific to Databases
6-18 Attributes Specific to Rules
6-19 Attributes Specific to Rule Sets
6-20 Attributes Specific to Evaluation Contexts
6-21 Attributes Specific to Table Aliases
6-22 Attributes Specific to Variable Types
6-23 Attributes Specific to Name-Value Pair
7-1 LOB Functions Compatibility and Migration
8-1 Global Transaction Identifier
8-2 One-Phase Commit
8-3 Two-Phase Commit
8-4 Read-Only Update Fails
8-5 Read-Only Transaction
8-6 Initialization and Termination Multithreading Functions
8-7 Passive Threading Primitives
8-8 Active Threading Primitives
9-1 Time and Event
9-2 AQ Functions
9-3 Enqueue Parameters
9-4 Dequeue Parameters
9-5 Listen Parameters
9-6 Array Enqueue Parameters
9-7 Array Dequeue Parameters
9-8 Agent Parameters
9-9 Message Properties
9-10 Enqueue Option Attributes
9-11 Dequeue Option Attributes
9-12 Publish-Subscribe Functions
10-1 Comparison of Some Connection Specific Auto-Tuning Parameters
10-2 Equivalent OCI Parameter Settings in oraaccess.xml and sqlnet.ora
11-1 Meta-Attributes of Persistent Objects
11-2 Set and Check Functions
11-3 Transient Meta-Attributes
11-4 Attribute Values for New Objects
12-1 Function Prefix Examples
12-2 Binding and Defining Datetime and Interval Data Types
12-3 Datetime Functions
12-4 Interval Functions
12-5 String Functions
12-6 Raw Functions
12-7 Collection Functions
12-8 Collection Scanning Functions
12-9 Nested Table Functions
12-10 REF Manipulation Functions
12-11 Descriptor Objects
12-12 Data Type Mappings for Binds and Defines
13-1 Direct Path Context Functions
13-2 Direct Path Column Array Functions
14-1 Object Attributes After a Refresh Operation
14-2 Example of Allocation and Pin Durations
14-3 Pin, Free, and Unpin Functions
14-4 Flush and Refresh Functions
14-5 Mark and Unmark Functions
14-6 Object Meta-Attributes Functions
14-7 Other Object Functions
15-1 Object Data Type Mappings for Object Type Attributes
16-1 Mode of a Parameter
16-2 Connect, Authorize, and Initialize Functions
16-3 Handle and Descriptor Functions
16-4 Bind, Define, and Describe Functions
17-1 Statement Functions
17-2 LOB Functions
17-3 Advanced Queuing and Publish-Subscribe Functions
17-4 Direct Path Loading Functions
17-5 Thread Management Functions
17-6 Transaction Functions
17-7 Miscellaneous Functions
17-8 OCI Function Codes
17-9 Continuation of OCI Function Codes from 97 and Higher
18-1 Type and Lifetime of Instances
18-2 Return Values of Navigational Functions
18-3 OCI Navigational Functions Error Codes
18-4 Flush or Refresh Functions
18-5 Object Status After Refresh
18-6 Mark or Unmark Object and Cache Functions
18-7 Get Object Status Functions
18-8 Miscellaneous Object Functions
18-9 Instances Created
18-10 Pin, Unpin, and Free Functions
18-11 Type Information Accessor Functions
19-1 Function Return Values
19-2 Collection and Iterator Functions
19-3 Element Pointers
19-4 Date Functions
19-5 Error Bits Returned by the valid Parameter for OCIDateCheck()
19-6 Comparison Results
19-7 Error Bits Returned by the valid Parameter for OCIDateTimeCheck()
19-8 Comparison Results Returned by the result Parameter for OCIDateTimeCompare()
19-9 Error Bits Returned by the valid Parameter for OCIIntervalCheck()
19-10 Comparison Results Returned by the result Parameter for OCIIntervalCompare()
19-11 NUMBER Functions
19-12 Comparison Results Returned by the result Parameter for OCINumberCmp()
19-13 Values of result
19-14 Raw Functions
19-15 Ref Functions
19-16 String Functions
19-17 Table Functions
20-1 External Procedures Functions
20-2 Memory Services Functions
20-3 Maintaining Context Functions
20-4 Parameter Manager Interface Functions
20-5 File I/O Interface Functions
20-6 String Formatting Functions
20-7 Format Modifier Flags
20-8 Format Codes to Specify How to Format an Argument Written to a String
21-1 Function Return Values
21-2 Type Interface Functions
21-3 Any Data Functions
21-4 Data Types and Attribute Values
21-5 Data Types and Attribute Values
21-6 Any Data Set Functions
22-1 Function Return Values
22-2 OCI Locale Functions
22-3 OCI Locale-Mapping Function
22-4 OCI String Manipulation Functions
22-5 OCI Character Classification Functions
22-6 OCI Character Set Conversion Functions
22-7 OCI Messaging Functions
23-1 Function Return Values
23-2 OCI XML DB Functions
26-1 Mode of a Parameter
26-2 OCI XStream Functions
26-3 Table Column Data Types
26-4 Required Column List in the First LCR
26-5 Storage of LOB or LONG Data in the LCR
A-1 SQL Command Codes
B-1 OCI Demonstration Programs
C-1 Server Round-Trips for Relational Operations
C-2 Server Round-Trips for OCILob Calls
C-3 Server Round-Trips for Object and Cache Functions
C-4 Server Round-Trips for Describe Operations
C-5 Server Round-Trips for Data Type Manipulation Functions
C-6 Server Round-Trips for Any Type and Data Functions
C-7 Locally Processed Functions
D-1 ORACLE_HOME Directories and Contents
D-2 Oracle XA Components
D-3 Link Libraries
E-1 Deprecated OCI Functions
E-2 Deprecated Initialize Functions
E-3 Deprecated Statement Functions
E-4 Deprecated LOB Functions
E-5 Characters or Bytes in amtp for OCILobRead()
E-6 Characters or Bytes in amtp for OCILobWrite()
E-7 Characters or Bytes in amtp for OCILobWriteAppend()
E-8 Deprecated Streams Advanced Queuing Functions
F-1 Agent Control Utility (agtctl) Commands
F-2 Configuration Parameters for agtctl

Page 4 of 84