Skip to main content
Oracle Help Center

Sign Out

Sign In

  • Table of Contents
  • Search
  • Print
  • Download
  1. Database
  2. Oracle
  3. Oracle Database
  4. Release 19

Programmer's Guide

  • Table of Contents
  • Search
  • Print
  • Download

Table of Contents

Expand AllCollapse All
  • List of Examples
  • List of Figures
  • List of Tables
  • Title and Copyright Information
  • Preface
    • Audience
    • Documentation Accessibility
    • Related Documents
    • Conventions
  • Changes in This Release for Oracle C++ Call Interface Programmer's Guide
    • Changes in Oracle Database Release 19c Version 19.1
      • Other Changes
    • Changes in Oracle Database Release 18c Version 18.1
      • New Features
    • Changes in Oracle Database 12c Release 2 (12.2.0.1)
      • New Features
  • 1 Introduction to OCCI
    • 1.1 Overview of OCCI
      • 1.1.1 About Benefits of OCCI
      • 1.1.2 About Building a C++ Application with OCCI
      • 1.1.3 About Functionality of OCCI
      • 1.1.4 About Procedural and Nonprocedural Elements
    • 1.2 About Processing SQL Statements
      • 1.2.1 About Data Definition Language Statements
      • 1.2.2 About Control Statements
      • 1.2.3 About Data Manipulation Language Statements
      • 1.2.4 About Queries
    • 1.3 Overview of PL/SQL
    • 1.4 About Special OCCI/SQL Terms
    • 1.5 About Object Support
      • 1.5.1 About Client-Side Object Cache
      • 1.5.2 About Run-time Environment for Objects
      • 1.5.3 About Associative and Navigational Interfaces
      • 1.5.4 About Interoperability with C (OCI)
      • 1.5.5 About the Metadata Class
      • 1.5.6 About the Object Type Translator Utility
    • 1.6 About Additional Support
      • 1.6.1 Building OCCI Demos
      • 1.6.2 About OCCI on the Oracle Technology Network
  • 2 Installation and Upgrading
    • 2.1 About Installing Oracle C++ Call Interface
    • 2.2 About Upgrading Considerations
    • 2.3 About Determining the Oracle Database Versions
      • 2.3.1 Determining the Oracle Client Version During Compilation
      • 2.3.2 About Determining the Oracle Client and Server Versions at Run Time
    • 2.4 About the Instant Client
      • 2.4.1 About Benefits of Instant Client
      • 2.4.2 About Installing the Instant Client
        • 2.4.2.1 About the Oracle Technology Network
          • 2.4.2.1.1 About the Instant Client SDK
        • 2.4.2.2 About the Complete Client Installation
        • 2.4.2.3 Running Oracle Universal Installer
        • 2.4.2.4 About the Instant Client CD
      • 2.4.3 About Using the Instant Client
      • 2.4.4 Patching Instant Client Shared Libraries on UNIX
      • 2.4.5 Regenerating the Data Shared Library and Zip Files
      • 2.4.6 About Database Connection Names for Instant Client
      • 2.4.7 Setting Environment Variables for OCCI Instant Client
    • 2.5 About Instant Client Light (English)
      • 2.5.1 About Globalization Settings for Instant Client Light (English)
      • 2.5.2 About Using Instant Client Light (English)
      • 2.5.3 About Installing Instant Client Light (English)
        • 2.5.3.1 Downloading from Oracle Technology Network
        • 2.5.3.2 About Using the Client Admin Install
        • 2.5.3.3 Installing with Oracle Universal Installer
    • 2.6 About Using OCCI with Microsoft Visual C++
  • 3 Accessing Oracle Database Using C++
    • 3.1 About Connecting to a Database
      • 3.1.1 Creating and Terminating an Environment
      • 3.1.2 Opening and Closing a Connection
      • 3.1.3 About Support for Pluggable Databases
    • 3.2 About Pooling Connections
      • 3.2.1 About Using Connection Pools
        • 3.2.1.1 Creating a Connection Pool
        • 3.2.1.2 Creating Proxy Connections
      • 3.2.2 Using Stateless Connection Pooling
      • 3.2.3 About Database Resident Connection Pooling
        • 3.2.3.1 Administrating Database Resident Connection Pools
        • 3.2.3.2 Using Database Resident Connection Pools
    • 3.3 About Executing SQL DDL and DML Statements
      • 3.3.1 Creating a Statement Object
      • 3.3.2 Creating a Statement Object that Executes SQL Commands
        • 3.3.2.1 Creating a Database Table
        • 3.3.2.2 Inserting Values into a Database Table
      • 3.3.3 Reusing the Statement Object
      • 3.3.4 Terminating a Statement Object
    • 3.4 About Types of SQL Statements in the OCCI Environment
      • 3.4.1 About Standard Statements
      • 3.4.2 Using Parameterized Statements
      • 3.4.3 Using Callable Statements
        • 3.4.3.1 Using Callable Statements that Use Array Parameters
      • 3.4.4 About Streamed Reads and Writes
        • 3.4.4.1 Binding Data in Streaming Mode; SELECT/DML and PL/SQL
        • 3.4.4.2 Fetching Data in Streaming Mode: PL/SQL
        • 3.4.4.3 About Fetching Data in Streaming Mode: ResultSet
        • 3.4.4.4 Working with Multiple Streams
      • 3.4.5 About Modifying Rows Iteratively
        • 3.4.5.1 Setting the Maximum Number of Iterations
        • 3.4.5.2 Setting the Maximum Parameter Size
        • 3.4.5.3 Executing an Iterative Operation
    • 3.5 About Executing SQL Queries
      • 3.5.1 Using the Result Set
      • 3.5.2 About Specifying the Query
      • 3.5.3 About Optimizing Performance by Setting Prefetch Count
    • 3.6 About Executing Statements Dynamically
      • 3.6.1 About Statement Status Definitions
        • 3.6.1.1 UNPREPARED
        • 3.6.1.2 PREPARED
        • 3.6.1.3 RESULT_SET_AVAILABLE
        • 3.6.1.4 UPDATE_COUNT_AVAILABLE
        • 3.6.1.5 NEEDS_STREAM_DATA
        • 3.6.1.6 STREAM_DATA_AVAILABLE
    • 3.7 About Using Larger Row Count and Error Code Range Data Types
      • 3.7.1 Using Larger Row Count in SELECT Operations
      • 3.7.2 Using Larger Row Count in INSERT, UPDATE, and DELETE Operations
    • 3.8 About Committing a Transaction
    • 3.9 Caching Statements
    • 3.10 About Handling Exceptions
      • 3.10.1 About Handling Null and Truncated Data
  • 4 Object Programming
    • 4.1 Overview of Object Programming
    • 4.2 About Working with Objects in C++ with OCCI
      • 4.2.1 About Persistent Objects
      • 4.2.2 About Transient Objects
      • 4.2.3 About Values
    • 4.3 About Representing Objects in C++ Applications
      • 4.3.1 Creating Persistent and Transient Objects
      • 4.3.2 Creating Object Representations using the OTT Utility
    • 4.4 About Developing a C++ Application using OCCI
      • 4.4.1 Developing Basic Object Program Structure
      • 4.4.2 About Basic Object Operational Flow
        • 4.4.2.1 About Initializing OCCI in Object Mode
        • 4.4.2.2 About Pinning anObject
        • 4.4.2.3 About Operating on an Object in Cache
        • 4.4.2.4 About Flushing Changes to the Object
        • 4.4.2.5 About Deletion of an Object
    • 4.5 Migrating C++ Applications to Oracle Using OCCI
    • 4.6 Overview of Associative Access
      • 4.6.1 Using SQL to Access Objects
      • 4.6.2 Inserting and Modifying Values
    • 4.7 Overview of Navigational Access
      • 4.7.1 Retrieving an Object Reference (REF) from the Database Server
      • 4.7.2 Pinning an Object
      • 4.7.3 Manipulating Object Attributes
      • 4.7.4 About Marking Objects and Flushing Changes
      • 4.7.5 Marking an Object as Modified (Dirty)
      • 4.7.6 About Recording Changes in the Database
      • 4.7.7 Collecting Garbage in the Object Cache
      • 4.7.8 About Ensuring Transactional Consistency of References
    • 4.8 Overview of Complex Object Retrieval
      • 4.8.1 Retrieving Complex Objects
      • 4.8.2 About Prefetching Complex Objects
    • 4.9 Working with Collections
      • 4.9.1 Fetching Embedded Objects
      • 4.9.2 About Nullness
    • 4.10 About Using Object References
    • 4.11 About Deleting Objects from the Database
    • 4.12 About Type Inheritance
      • 4.12.1 About Substitutability
      • 4.12.2 Declaring NOT INSTANTIABLE Types and Methods
      • 4.12.3 About OCCI Support for Type Inheritance
        • 4.12.3.1 About Connection::getMetaData()
        • 4.12.3.2 About Bind and Define Functions
      • 4.12.4 About OTT Support for Type Inheritance
    • 4.13 A Sample OCCI Application
  • 5 Data Types
    • 5.1 Overview of Oracle Data Types
      • 5.1.1 About OCCI Type and Data Conversion
    • 5.2 Internal Data Types
      • 5.2.1 Character Strings and Byte Arrays
      • 5.2.2 Universal Rowid (UROWID)
    • 5.3 External Data Types
      • 5.3.1 Description of External Data Types
        • 5.3.1.1 BFILE
        • 5.3.1.2 BDOUBLE
        • 5.3.1.3 BFLOAT
        • 5.3.1.4 BLOB
        • 5.3.1.5 CHAR
        • 5.3.1.6 CHARZ
        • 5.3.1.7 CLOB
        • 5.3.1.8 DATE
          • 5.3.1.8.1 Example 1, 01-JUN-2000, 3:17PM:
          • 5.3.1.8.2 Example 2, 01-JAN-4712 BCE:
        • 5.3.1.9 FLOAT
        • 5.3.1.10 INTEGER
        • 5.3.1.11 INTERVAL DAY TO SECOND
        • 5.3.1.12 INTERVAL YEAR TO MONTH
        • 5.3.1.13 LONG
        • 5.3.1.14 LONG RAW
        • 5.3.1.15 LONG VARCHAR
        • 5.3.1.16 LONG VARRAW
        • 5.3.1.17 NCLOB
        • 5.3.1.18 NUMBER
        • 5.3.1.19 OCCI BFILE
        • 5.3.1.20 OCCI BLOB
        • 5.3.1.21 OCCI BYTES
        • 5.3.1.22 OCCI CLOB
        • 5.3.1.23 OCCI DATE
        • 5.3.1.24 OCCI INTERVALDS
        • 5.3.1.25 OCCI INTERVALYM
        • 5.3.1.26 OCCI NUMBER
        • 5.3.1.27 OCCI POBJECT
        • 5.3.1.28 OCCI REF
        • 5.3.1.29 OCCI REFANY
        • 5.3.1.30 OCCI STRING
        • 5.3.1.31 OCCI TIMESTAMP
        • 5.3.1.32 OCCI VECTOR
        • 5.3.1.33 RAW
        • 5.3.1.34 REF
        • 5.3.1.35 ROWID
        • 5.3.1.36 STRING
        • 5.3.1.37 TIMESTAMP
        • 5.3.1.38 TIMESTAMP WITH LOCAL TIME ZONE
        • 5.3.1.39 TIMESTAMP WITH TIME ZONE
        • 5.3.1.40 UNSIGNED INT
        • 5.3.1.41 VARCHAR
        • 5.3.1.42 VARCHAR2
        • 5.3.1.43 VARNUM
        • 5.3.1.44 VARRAW
        • 5.3.1.45 NATIVE DOUBLE
        • 5.3.1.46 NATIVE FLOAT
    • 5.4 Data Conversions
      • 5.4.1 Data Conversions for LOB Data Types
      • 5.4.2 Data Conversions for Date, Timestamp, and Interval Data Types
  • 6 Metadata
    • 6.1 Overview of Metadata
    • 6.2 Using Identity Column Metadata
    • 6.3 About Describing Database Metadata
      • 6.3.1 Using Metadata (Code Examples)
    • 6.4 Attribute Reference Information
      • 6.4.1 Parameter Attributes
      • 6.4.2 Table and View Attributes
      • 6.4.3 Procedure, Function, and Subprogram Attributes
      • 6.4.4 Package Attributes
      • 6.4.5 Type Attributes
      • 6.4.6 Type Attribute Attributes
      • 6.4.7 Type Method Attributes
      • 6.4.8 Collection Attributes
      • 6.4.9 Synonym Attributes
      • 6.4.10 Sequence Attributes
      • 6.4.11 Column Attributes
      • 6.4.12 Argument and Result Attributes
      • 6.4.13 List Attributes
      • 6.4.14 Schema Attributes
      • 6.4.15 Database Attributes
  • 7 Programming with LOBs
    • 7.1 Overview of LOBs
      • 7.1.1 Introducing Internal LOBs
      • 7.1.2 Introducing External LOBs
      • 7.1.3 About Storing LOBs
    • 7.2 Creating LOBs in OCCI Applications
    • 7.3 Restricting the Opening and Closing of LOBs
    • 7.4 About Reading and Writing LOBs
      • 7.4.1 Reading LOBs
      • 7.4.2 Writing LOBs
      • 7.4.3 About Enhancing the Performance of LOB Reads and Writes
        • 7.4.3.1 About Using the getChunkSize() Method
      • 7.4.4 Updating LOBs
      • 7.4.5 About Reading and Writing Multiple LOBs
        • 7.4.5.1 About Using the Interfaces for Reading and Writing Multiple LOBs
    • 7.5 Using Objects with LOB Attributes
    • 7.6 About Using SecureFiles
      • 7.6.1 About Using SecureFile Compression
      • 7.6.2 About Using SecureFiles Encryption
      • 7.6.3 About Using SecureFiles Deduplication
      • 7.6.4 About Combining SecureFiles Compression, Encryption, and Deduplication
      • 7.6.5 SecureFiles LOB Types and Constants
  • 8 Object Type Translator Utility
    • 8.1 Overview of the Object Type Translator Utility
    • 8.2 Using the OTT Utility
    • 8.3 Creating Types in the Database
    • 8.4 About Invoking the OTT Utility
      • 8.4.1 Specifying OTT Parameters
        • 8.4.1.1 About Setting Parameters on the Command Line
        • 8.4.1.2 About Setting Parameters in the INTYPE File
        • 8.4.1.3 About Setting Parameters in the Configuration File
      • 8.4.2 Invoking the OTT Utility on the Command Line
        • 8.4.2.1 Elements Used on the OTT Command Line
      • 8.4.3 OTT Utility Parameters
        • 8.4.3.1 ATTRACCESS
        • 8.4.3.2 CASE
        • 8.4.3.3 CODE
        • 8.4.3.4 CONFIG
        • 8.4.3.5 CPPFILE
        • 8.4.3.6 ERRTYPE
        • 8.4.3.7 HFILE
        • 8.4.3.8 INTYPE
        • 8.4.3.9 MAPFILE
        • 8.4.3.10 MAPFUNC
        • 8.4.3.11 OUTTYPE
        • 8.4.3.12 SCHEMA_NAMES
        • 8.4.3.13 TRANSITIVE
        • 8.4.3.14 UNICODE
        • 8.4.3.15 USE_MARKER
        • 8.4.3.16 USERID
      • 8.4.4 Where OTT Parameters Can Appear
      • 8.4.5 File Name Comparison Restriction
      • 8.4.6 Using the OTT Command on Microsoft Windows
    • 8.5 About Using the INTYPE File
      • 8.5.1 Using the INTYPE File
      • 8.5.2 Structure of the INTYPE File
        • 8.5.2.1 INTYPE File Type Specifications
      • 8.5.3 Using Nested include File Generation
    • 8.6 Using OTT Utility Data Type Mappings
      • 8.6.1 Default Name Mapping
    • 8.7 Overview of the OUTTYPE File
    • 8.8 Using the OTT Utility and OCCI Applications
    • 8.9 Generating C++ Classes Generated by the OTT Utility
      • 8.9.1 Map Registry Function
      • 8.9.2 Extending C++ Classes
      • 8.9.3 Carrying Forward User Added Code
        • 8.9.3.1 How to Use Properties of OTT Markers
        • 8.9.3.2 Using OTT Markers
  • 9 Globalization and Unicode Support
    • 9.1 Overview of Globalization and Unicode Support
    • 9.2 Specifying Charactersets
    • 9.3 Data Types for Globalization and Unicode Support
      • 9.3.1 Using the UString Data Type
      • 9.3.2 Using Multibyte and UTF16 data
      • 9.3.3 Using CLOB and NCLOB Data Types
    • 9.4 About Using Objects and OTT Support
  • 10 Oracle Database Advanced Queuing
    • 10.1 Overview of Oracle Database Advanced Queuing
    • 10.2 About AQ Implementation in OCCI
      • 10.2.1 Message
      • 10.2.2 Agent
      • 10.2.3 Producer
      • 10.2.4 Consumer
      • 10.2.5 Listener
      • 10.2.6 Subscription
    • 10.3 About Creating Messages
      • 10.3.1 About Message Payloads
        • 10.3.1.1 RAW
        • 10.3.1.2 AnyData
        • 10.3.1.3 Using User-defined Types as Payloads
      • 10.3.2 Message Properties
        • 10.3.2.1 Correlation
        • 10.3.2.2 Sender
        • 10.3.2.3 Delay and Expiration
        • 10.3.2.4 Recipients
        • 10.3.2.5 Priority and Ordering
    • 10.4 Enqueuing Messages
    • 10.5 Dequeuing Messages
      • 10.5.1 About Dequeuing Options
        • 10.5.1.1 Correlation
        • 10.5.1.2 Mode
        • 10.5.1.3 Navigation
    • 10.6 Listening for Messages
    • 10.7 About Registering for Notification
      • 10.7.1 Publish-Subscribe Notifications
        • 10.7.1.1 How to Use Direct Registration
        • 10.7.1.2 Using Open Registration
      • 10.7.2 About Notification Callback
    • 10.8 About Message Format Transformation
  • 11 Oracle XA Library
    • 11.1 Developing Applications with XA and OCCI
    • 11.2 APIs for XA Support
  • 12 Optimizing Performance of C++ Applications
    • 12.1 About Transparent Application Failover
      • 12.1.1 Using Transparent Application Failover
      • 12.1.2 About Objects and Transparent Application Failover
      • 12.1.3 Using Connection Pooling and Transparent Application Failover
    • 12.2 About Connection Sharing
      • 12.2.1 Introduction to Thread Safety
      • 12.2.2 Implementing Thread Safety
      • 12.2.3 About Serialization
        • 12.2.3.1 Automatic Serialization
        • 12.2.3.2 Application-Provided Serialization
      • 12.2.4 Operating System Considerations
    • 12.3 About Application-Managed Data Buffering
      • 12.3.1 Using the setDataBuffer() Method
      • 12.3.2 Using the executeArrayUpdate() Method
    • 12.4 Using the Array Fetch Using next() Method
    • 12.5 Modifying Rows Iteratively
    • 12.6 About Using Oracle Connection Manager in Traffic Director Mode
    • 12.7 About Run-time Load Balancing of the Stateless Connection Pool
      • 12.7.1 API Support
    • 12.8 About Fault Diagnosability
      • 12.8.1 Using ADR Base Location
      • 12.8.2 Using ADRCI
      • 12.8.3 Controlling ADR Creation and Disabling Fault Diagnosability
    • 12.9 Using Client Result Cache
    • 12.10 About Client-Side Deployment Parameters and Auto Tuning
  • 13 OCCI Application Programming Interface
    • 13.1 OCCI Classes and Methods
      • 13.1.1 Using OCCI Classes
      • 13.1.2 OCCI Support for Windows NT and z/OS
        • 13.1.2.1 Working with Collections of Refs
          • 13.1.2.1.1 ResultSet Class
          • 13.1.2.1.2 Statement Class
    • 13.2 Common OCCI Constants
    • 13.3 Agent Class
      • 13.3.1 Agent()
      • 13.3.2 getAddress()
      • 13.3.3 getName()
      • 13.3.4 getProtocol()
      • 13.3.5 isNull()
      • 13.3.6 operator=()
      • 13.3.7 setAddress()
      • 13.3.8 setName()
      • 13.3.9 setNull()
      • 13.3.10 setProtocol()
    • 13.4 AnyData Class
      • 13.4.1 AnyData()
      • 13.4.2 getAsBDouble()
      • 13.4.3 getAsBfile()
      • 13.4.4 getAsBFloat()
      • 13.4.5 getAsBytes()
      • 13.4.6 getAsDate()
      • 13.4.7 getAsIntervalDS()
      • 13.4.8 getAsIntervalYM()
      • 13.4.9 getAsNumber()
      • 13.4.10 getAsObject()
      • 13.4.11 getAsRef()
      • 13.4.12 getAsString()
      • 13.4.13 getAsTimestamp()
      • 13.4.14 getType()
      • 13.4.15 isNull()
      • 13.4.16 setFromBDouble()
      • 13.4.17 setFromBfile()
      • 13.4.18 setFromBFloat()
      • 13.4.19 setFromBytes()
      • 13.4.20 setFromDate()
      • 13.4.21 setFromIntervalDS()
      • 13.4.22 setFromIntervalYM()
      • 13.4.23 setFromNumber()
      • 13.4.24 setFromObject()
      • 13.4.25 setFromRef()
      • 13.4.26 setFromString()
      • 13.4.27 setFromTimestamp()
      • 13.4.28 setNull()
    • 13.5 BatchSQLException Class
      • 13.5.1 getException()
      • 13.5.2 getFailedRowCount()
      • 13.5.3 getRowNum()
    • 13.6 Bfile Class
      • 13.6.1 Bfile()
      • 13.6.2 close()
      • 13.6.3 closeStream()
      • 13.6.4 fileExists()
      • 13.6.5 getDirAlias()
      • 13.6.6 getFileName()
      • 13.6.7 getStream()
      • 13.6.8 getUStringDirAlias()
      • 13.6.9 getUStringFileName()
      • 13.6.10 isInitialized()
      • 13.6.11 isNull()
      • 13.6.12 isOpen()
      • 13.6.13 length()
      • 13.6.14 open()
      • 13.6.15 operator=()
      • 13.6.16 operator==()
      • 13.6.17 operator!=()
      • 13.6.18 read()
      • 13.6.19 setName()
      • 13.6.20 setNull()
    • 13.7 Blob Class
      • 13.7.1 Blob()
      • 13.7.2 append()
      • 13.7.3 close()
      • 13.7.4 closeStream()
      • 13.7.5 copy()
      • 13.7.6 getChunkSize()
      • 13.7.7 getContentType()
      • 13.7.8 getOptions()
      • 13.7.9 getStream()
      • 13.7.10 isInitialized()
      • 13.7.11 isNull()
      • 13.7.12 isOpen()
      • 13.7.13 length()
      • 13.7.14 open()
      • 13.7.15 operator=()
      • 13.7.16 operator==()
      • 13.7.17 operator!= ()
      • 13.7.18 read()
      • 13.7.19 setContentType()
      • 13.7.20 setEmpty()
      • 13.7.21 setNull()
      • 13.7.22 setOptions()
      • 13.7.23 trim()
      • 13.7.24 write()
      • 13.7.25 writeChunk()
    • 13.8 Bytes Class
      • 13.8.1 Bytes()
      • 13.8.2 byteAt()
      • 13.8.3 getBytes()
      • 13.8.4 isNull()
      • 13.8.5 length()
      • 13.8.6 operator=()
      • 13.8.7 setNull()
    • 13.9 Clob Class
      • 13.9.1 Clob()
      • 13.9.2 append()
      • 13.9.3 close()
      • 13.9.4 closeStream()
      • 13.9.5 copy()
      • 13.9.6 getCharSetForm()
      • 13.9.7 getCharSetId()
      • 13.9.8 getCharSetIdUString()
      • 13.9.9 getChunkSize()
      • 13.9.10 getContentType()
      • 13.9.11 getOptions()
      • 13.9.12 getStream()
      • 13.9.13 isInitialized()
      • 13.9.14 isNull()
      • 13.9.15 isOpen()
      • 13.9.16 length()
      • 13.9.17 open()
      • 13.9.18 operator=()
      • 13.9.19 operator==()
      • 13.9.20 operator!=()
      • 13.9.21 read()
      • 13.9.22 setCharSetId()
      • 13.9.23 setCharSetIdUString()
      • 13.9.24 setCharSetForm()
      • 13.9.25 setContentType()
      • 13.9.26 setEmpty()
      • 13.9.27 setNull()
      • 13.9.28 setOptions()
      • 13.9.29 trim()
      • 13.9.30 write()
      • 13.9.31 writeChunk()
    • 13.10 Connection Class
      • 13.10.1 changePassword()
      • 13.10.2 commit()
      • 13.10.3 createStatement()
      • 13.10.4 flushCache()
      • 13.10.5 getClientCharSet()
      • 13.10.6 getClientCharSetUString()
      • 13.10.7 getClientNCHARCharSet()
      • 13.10.8 getClientNCHARCharSetUString()
      • 13.10.9 getClientVersion()
      • 13.10.10 getLTXID()
      • 13.10.11 getMetaData()
      • 13.10.12 getOCIServer()
      • 13.10.13 getOCIServiceContext()
      • 13.10.14 getOCISession()
      • 13.10.15 getServerVersion()
      • 13.10.16 getServerVersionUString()
      • 13.10.17 getStmtCacheSize()
      • 13.10.18 getTag()
      • 13.10.19 isCached()
      • 13.10.20 pinVectorOfRefs()
      • 13.10.21 postToSubscriptions()
      • 13.10.22 readVectorOfBfiles()
      • 13.10.23 readVectorOfBlobs()
      • 13.10.24 readVectorOfClobs()
      • 13.10.25 registerSubscriptions()
      • 13.10.26 rollback()
      • 13.10.27 setStmtCacheSize()
      • 13.10.28 setTAFNotify()
      • 13.10.29 terminateStatement()
      • 13.10.30 unregisterSubscription()
      • 13.10.31 writeVectorOfBlobs()
      • 13.10.32 writeVectorOfClobs()
    • 13.11 ConnectionPool Class
      • 13.11.1 createConnection()
      • 13.11.2 createProxyConnection()
      • 13.11.3 getBusyConnections()
      • 13.11.4 getIncrConnections()
      • 13.11.5 getMaxConnections()
      • 13.11.6 getMinConnections()
      • 13.11.7 getOpenConnections()
      • 13.11.8 getPoolName()
      • 13.11.9 getStmtCacheSize()
      • 13.11.10 getTimeOut()
      • 13.11.11 setErrorOnBusy()
      • 13.11.12 setPoolSize()
      • 13.11.13 setStmtCacheSize()
      • 13.11.14 setTimeOut()
      • 13.11.15 terminateConnection()
    • 13.12 Consumer Class
      • 13.12.1 Consumer()
      • 13.12.2 getConsumerName()
      • 13.12.3 getCorrelationId()
      • 13.12.4 getDequeueMode()
      • 13.12.5 getMessageIdToDequeue()
      • 13.12.6 getPositionOfMessage()
      • 13.12.7 getQueueName()
      • 13.12.8 getTransformation()
      • 13.12.9 getVisibility()
      • 13.12.10 getWaitTime()
      • 13.12.11 isNull()
      • 13.12.12 operator=()
      • 13.12.13 receive()
      • 13.12.14 setAgent()
      • 13.12.15 setConsumerName()
      • 13.12.16 setCorrelationId()
      • 13.12.17 setDequeueMode()
      • 13.12.18 setMessageIdToDequeue()
      • 13.12.19 setNull()
      • 13.12.20 setPositionOfMessage()
      • 13.12.21 setQueueName()
      • 13.12.22 setTransformation()
      • 13.12.23 setVisibility()
      • 13.12.24 setWaitTime()
    • 13.13 Date Class
      • 13.13.1 Date()
      • 13.13.2 addDays()
      • 13.13.3 addMonths()
      • 13.13.4 daysBetween()
      • 13.13.5 fromBytes()
      • 13.13.6 fromText()
      • 13.13.7 getDate()
      • 13.13.8 getSystemDate()
      • 13.13.9 isNull()
      • 13.13.10 lastDay()
      • 13.13.11 nextDay()
      • 13.13.12 operator=()
      • 13.13.13 operator==()
      • 13.13.14 operator!=()
      • 13.13.15 operator>()
      • 13.13.16 operator>=()
      • 13.13.17 operator<()
      • 13.13.18 operator<=()
      • 13.13.19 setDate()
      • 13.13.20 setNull()
      • 13.13.21 toBytes()
      • 13.13.22 toText()
      • 13.13.23 toZone()
    • 13.14 Environment Class
      • 13.14.1 createConnection()
      • 13.14.2 createConnectionPool()
      • 13.14.3 createEnvironment()
      • 13.14.4 createStatelessConnectionPool()
      • 13.14.5 enableSubscription()
      • 13.14.6 disableSubscription()
      • 13.14.7 getCacheMaxSize()
      • 13.14.8 getCacheOptSize()
      • 13.14.9 getCacheSortedFlush()
      • 13.14.10 getCurrentHeapSize()
      • 13.14.11 getLDAPAdminContext()
      • 13.14.12 getLDAPAuthentication()
      • 13.14.13 getLDAPHost()
      • 13.14.14 getLDAPPort()
      • 13.14.15 getMap()
      • 13.14.16 getNLSLanguage()
      • 13.14.17 getNLSTerritory()
      • 13.14.18 getOCIEnvironment()
      • 13.14.19 getXAConnection()
      • 13.14.20 getXAEnvironment()
      • 13.14.21 releaseXAConnection()
      • 13.14.22 releaseXAEnvironment()
      • 13.14.23 setCacheMaxSize()
      • 13.14.24 setCacheOptSize()
      • 13.14.25 setCacheSortedFlush()
      • 13.14.26 setLDAPAdminContext()
      • 13.14.27 setLDAPAuthentication()
      • 13.14.28 setLDAPHostAndPort()
      • 13.14.29 setLDAPLoginNameAndPassword()
      • 13.14.30 setNLSLanguage()
      • 13.14.31 setNLSTerritory()
      • 13.14.32 terminateConnection()
      • 13.14.33 terminateConnectionPool()
      • 13.14.34 terminateEnvironment()
      • 13.14.35 terminateStatelessConnectionPool()
    • 13.15 IntervalDS Class
      • 13.15.1 IntervalDS()
      • 13.15.2 fromText()
      • 13.15.3 fromUText()
      • 13.15.4 getDay()
      • 13.15.5 getFracSec()
      • 13.15.6 getHour()
      • 13.15.7 getMinute()
      • 13.15.8 getSecond()
      • 13.15.9 isNull()
      • 13.15.10 operator*()
      • 13.15.11 operator*=()
      • 13.15.12 operator=()
      • 13.15.13 operator==()
      • 13.15.14 operator!=()
      • 13.15.15 operator/()
      • 13.15.16 operator/=()
      • 13.15.17 operator>()
      • 13.15.18 operator>=()
      • 13.15.19 operator<()
      • 13.15.20 operator<=()
      • 13.15.21 operator-()
      • 13.15.22 operator-=()
      • 13.15.23 operator+()
      • 13.15.24 operator+=()
      • 13.15.25 set()
      • 13.15.26 setNull()
      • 13.15.27 toText()
      • 13.15.28 toUText()
    • 13.16 IntervalYM Class
      • 13.16.1 IntervalYM()
      • 13.16.2 fromText()
      • 13.16.3 fromUText()
      • 13.16.4 getMonth()
      • 13.16.5 getYear()
      • 13.16.6 isNull()
      • 13.16.7 operator*()
      • 13.16.8 operator*=()
      • 13.16.9 operator=()
      • 13.16.10 operator==()
      • 13.16.11 operator!=()
      • 13.16.12 operator/()
      • 13.16.13 operator/=()
      • 13.16.14 operator>()
      • 13.16.15 operator>=()
      • 13.16.16 operator<()
      • 13.16.17 operator<=()
      • 13.16.18 operator-()
      • 13.16.19 operator-=()
      • 13.16.20 operator+()
      • 13.16.21 operator+=()
      • 13.16.22 set()
      • 13.16.23 setNull()
      • 13.16.24 toText()
      • 13.16.25 toUText()
    • 13.17 Listener Class
      • 13.17.1 Listener()
      • 13.17.2 getAgentList()
      • 13.17.3 getTimeOutForListen()
      • 13.17.4 listen()
      • 13.17.5 setAgentList()
      • 13.17.6 setTimeOutForListen()
    • 13.18 Map Class
      • 13.18.1 put()
    • 13.19 Message Class
      • 13.19.1 Message()
      • 13.19.2 getAnyData()
      • 13.19.3 getAttemptsToDequeue()
      • 13.19.4 getBytes()
      • 13.19.5 getCorrelationId()
      • 13.19.6 getDelay()
      • 13.19.7 getExceptionQueueName()
      • 13.19.8 getExpiration()
      • 13.19.9 getMessageEnqueuedTime()
      • 13.19.10 getMessageState()
      • 13.19.11 getObject()
      • 13.19.12 getOriginalMessageId()
      • 13.19.13 getPayloadType()
      • 13.19.14 getPriority()
      • 13.19.15 getSenderId()
      • 13.19.16 isNull()
      • 13.19.17 operator=()
      • 13.19.18 setAnyData()
      • 13.19.19 setBytes()
      • 13.19.20 setCorrelationId()
      • 13.19.21 setDelay()
      • 13.19.22 setExceptionQueueName()
      • 13.19.23 setExpiration()
      • 13.19.24 setNull()
      • 13.19.25 setObject()
      • 13.19.26 setOriginalMessageId()
      • 13.19.27 setPriority()
      • 13.19.28 setRecipientList()
      • 13.19.29 setSenderId()
    • 13.20 MetaData Class
      • 13.20.1 MetaData()
      • 13.20.2 getAttributeCount()
      • 13.20.3 getAttributeId()
      • 13.20.4 getAttributeType()
      • 13.20.5 getBoolean()
      • 13.20.6 getInt()
      • 13.20.7 getMetaData()
      • 13.20.8 getNumber()
      • 13.20.9 getRef()
      • 13.20.10 getString()
      • 13.20.11 getTimeStamp()
      • 13.20.12 getUInt()
      • 13.20.13 getUString()
      • 13.20.14 getVector()
      • 13.20.15 operator=()
    • 13.21 NotifyResult Class
      • 13.21.1 getConsumerName()
      • 13.21.2 getMessage()
      • 13.21.3 getMessageId()
      • 13.21.4 getPayload()
      • 13.21.5 getQueueName()
    • 13.22 Number Class
      • 13.22.1 Number()
      • 13.22.2 abs()
      • 13.22.3 arcCos()
      • 13.22.4 arcSin()
      • 13.22.5 arcTan()
      • 13.22.6 arcTan2()
      • 13.22.7 ceil()
      • 13.22.8 cos()
      • 13.22.9 exp()
      • 13.22.10 floor()
      • 13.22.11 fromBytes()
      • 13.22.12 fromText()
      • 13.22.13 hypCos()
      • 13.22.14 hypSin()
      • 13.22.15 hypTan()
      • 13.22.16 intPower()
      • 13.22.17 isNull()
      • 13.22.18 ln()
      • 13.22.19 log()
      • 13.22.20 operator++()
      • 13.22.21 operator--()
      • 13.22.22 operator*()
      • 13.22.23 operator/()
      • 13.22.24 operator%()
      • 13.22.25 operator+()
      • 13.22.26 operator-()
      • 13.22.27 operator-()
      • 13.22.28 operator<()
      • 13.22.29 operator<=()
      • 13.22.30 operator>()
      • 13.22.31 operator>=()
      • 13.22.32 operator==()
      • 13.22.33 operator!=()
      • 13.22.34 operator=()
      • 13.22.35 operator*=()
      • 13.22.36 operator/=()
      • 13.22.37 operator%=()
      • 13.22.38 operator+=()
      • 13.22.39 operator-=()
      • 13.22.40 operator char()
      • 13.22.41 operator signed char()
      • 13.22.42 operator double()
      • 13.22.43 operator float()
      • 13.22.44 operator int()
      • 13.22.45 operator long()
      • 13.22.46 operator long double()
      • 13.22.47 operator short()
      • 13.22.48 operator unsigned char()
      • 13.22.49 operator unsigned int()
      • 13.22.50 operator unsigned long()
      • 13.22.51 operator unsigned short()
      • 13.22.52 power()
      • 13.22.53 prec()
      • 13.22.54 round()
      • 13.22.55 setNull()
      • 13.22.56 shift()
      • 13.22.57 sign()
      • 13.22.58 sin()
      • 13.22.59 squareroot()
      • 13.22.60 tan()
      • 13.22.61 toBytes()
      • 13.22.62 toText()
      • 13.22.63 trunc()
    • 13.23 PObject Class
      • 13.23.1 PObject()
      • 13.23.2 flush()
      • 13.23.3 getConnection()
      • 13.23.4 getRef()
      • 13.23.5 getSQLTypeName()
      • 13.23.6 isLocked()
      • 13.23.7 isNull()
      • 13.23.8 lock()
      • 13.23.9 markDelete()
      • 13.23.10 markModified()
      • 13.23.11 operator=()
      • 13.23.12 operator delete()
      • 13.23.13 operator new()
      • 13.23.14 pin()
      • 13.23.15 setNull()
      • 13.23.16 unmark()
      • 13.23.17 unpin()
    • 13.24 Producer Class
      • 13.24.1 Producer()
      • 13.24.2 getQueueName()
      • 13.24.3 getRelativeMessageId()
      • 13.24.4 getSequenceDeviation()
      • 13.24.5 getTransformation()
      • 13.24.6 getVisibility()
      • 13.24.7 isNull()
      • 13.24.8 operator=()
      • 13.24.9 send()
      • 13.24.10 setNull()
      • 13.24.11 setQueueName()
      • 13.24.12 setRelativeMessageId()
      • 13.24.13 setSequenceDeviation()
      • 13.24.14 setTransformation()
      • 13.24.15 setVisibility()
    • 13.25 Ref Class
      • 13.25.1 Ref()
      • 13.25.2 clear()
      • 13.25.3 getConnection()
      • 13.25.4 isClear()
      • 13.25.5 isNull()
      • 13.25.6 markDelete()
      • 13.25.7 operator->()
      • 13.25.8 operator*()
      • 13.25.9 operator==()
      • 13.25.10 operator!=()
      • 13.25.11 operator=()
      • 13.25.12 ptr()
      • 13.25.13 setLock()
      • 13.25.14 setNull()
      • 13.25.15 setPrefetch()
      • 13.25.16 unmarkDelete()
    • 13.26 RefAny Class
      • 13.26.1 RefAny()
      • 13.26.2 clear()
      • 13.26.3 getConnection()
      • 13.26.4 isNull()
      • 13.26.5 markDelete()
      • 13.26.6 operator=()
      • 13.26.7 operator==()
      • 13.26.8 operator!=()
      • 13.26.9 unmarkDelete()
    • 13.27 ResultSet Class
      • 13.27.1 cancel()
      • 13.27.2 closeStream()
      • 13.27.3 getBDouble()
      • 13.27.4 getBfile()
      • 13.27.5 getBFloat()
      • 13.27.6 getBlob()
      • 13.27.7 getBytes()
      • 13.27.8 getCharSet()
      • 13.27.9 getCharSetUString()
      • 13.27.10 getClob()
      • 13.27.11 getColumnListMetaData()
      • 13.27.12 getCurrentStreamColumn()
      • 13.27.13 getCurrentStreamRow()
      • 13.27.14 getCursor()
      • 13.27.15 getDatabaseNCHARParam()
      • 13.27.16 getDate()
      • 13.27.17 getDouble()
      • 13.27.18 getFloat()
      • 13.27.19 getInt()
      • 13.27.20 getIntervalDS()
      • 13.27.21 getIntervalYM()
      • 13.27.22 getMaxColumnSize()
      • 13.27.23 getNumArrayRows()
      • 13.27.24 getNumber()
      • 13.27.25 getObject()
      • 13.27.26 getRef()
      • 13.27.27 getRowid()
      • 13.27.28 getRowPosition()
      • 13.27.29 getStatement()
      • 13.27.30 getStream()
      • 13.27.31 getString()
      • 13.27.32 getTimestamp()
      • 13.27.33 getUInt()
      • 13.27.34 getUString()
      • 13.27.35 getVector()
      • 13.27.36 getVectorOfRefs()
      • 13.27.37 isNull()
      • 13.27.38 isTruncated()
      • 13.27.39 next()
      • 13.27.40 preTruncationLength()
      • 13.27.41 setBinaryStreamMode()
      • 13.27.42 setCharacterStreamMode()
      • 13.27.43 setCharSet()
      • 13.27.44 setCharSetUString()
      • 13.27.45 setDatabaseNCHARParam()
      • 13.27.46 setDataBuffer()
      • 13.27.47 setErrorOnNull()
      • 13.27.48 setErrorOnTruncate()
      • 13.27.49 setPrefetchMemorySize()
      • 13.27.50 setPrefetchRowCount()
      • 13.27.51 setMaxColumnSize()
      • 13.27.52 status()
    • 13.28 SQLException Class
      • 13.28.1 SQLException()
      • 13.28.2 getErrorCode()
      • 13.28.3 getMessage()
      • 13.28.4 getNLSMessage()
      • 13.28.5 getNLSUStringMessage()
      • 13.28.6 getUStringMessage()
      • 13.28.7 getXAErrorCode()
      • 13.28.8 isRecoverable()
      • 13.28.9 setErrorCtx()
      • 13.28.10 what()
    • 13.29 StatelessConnectionPool Class
      • 13.29.1 getAnyTaggedConnection()
      • 13.29.2 getAnyTaggedProxyConnection()
      • 13.29.3 getBusyConnections()
      • 13.29.4 getBusyOption()
      • 13.29.5 getConnection()
      • 13.29.6 getIncrConnections()
      • 13.29.7 getMaxConnections()
      • 13.29.8 getMinConnections()
      • 13.29.9 getOpenConnections()
      • 13.29.10 getPoolName()
      • 13.29.11 getProxyConnection()
      • 13.29.12 getStmtCacheSize()
      • 13.29.13 getTimeOut()
      • 13.29.14 releaseConnection()
      • 13.29.15 setBusyOption()
      • 13.29.16 setPoolSize()
      • 13.29.17 setTimeOut()
      • 13.29.18 setStmtCacheSize()
      • 13.29.19 terminateConnection()
    • 13.30 Statement Class
      • 13.30.1 addIteration()
      • 13.30.2 closeResultSet()
      • 13.30.3 closeStream()
      • 13.30.4 disableCaching()
      • 13.30.5 execute()
      • 13.30.6 executeArrayUpdate()
      • 13.30.7 executeQuery()
      • 13.30.8 executeUpdate()
      • 13.30.9 getAutoCommit()
      • 13.30.10 getBatchErrorMode()
      • 13.30.11 getBDouble()
      • 13.30.12 getBfile()
      • 13.30.13 getBFloat()
      • 13.30.14 getBlob()
      • 13.30.15 getBytes()
      • 13.30.16 getCharSet()
      • 13.30.17 getCharSetUString()
      • 13.30.18 getClob()
      • 13.30.19 getConnection()
      • 13.30.20 getCurrentIteration()
      • 13.30.21 getCurrentStreamIteration()
      • 13.30.22 getCurrentStreamParam()
      • 13.30.23 getCursor()
      • 13.30.24 getDatabaseNCHARParam()
      • 13.30.25 getDate()
      • 13.30.26 getDMLRowCounts()
      • 13.30.27 getDouble()
      • 13.30.28 getFloat()
      • 13.30.29 getInt()
      • 13.30.30 getIntervalDS()
      • 13.30.31 getIntervalYM()
      • 13.30.32 getMaxIterations()
      • 13.30.33 getMaxParamSize()
      • 13.30.34 getNumber()
      • 13.30.35 getObject()
      • 13.30.36 getOCIStatement()
      • 13.30.37 getRef()
      • 13.30.38 getResultSet()
      • 13.30.39 getRowCountsOption()
      • 13.30.40 getRowid()
      • 13.30.41 getSQL()
      • 13.30.42 getSQLUString()
      • 13.30.43 getStream()
      • 13.30.44 getString()
      • 13.30.45 getTimestamp()
      • 13.30.46 getUb8RowCount()
      • 13.30.47 getUInt()
      • 13.30.48 getUpdateCount()
      • 13.30.49 getUString()
      • 13.30.50 getVector()
      • 13.30.51 getVectorOfRefs()
      • 13.30.52 isNull()
      • 13.30.53 isTruncated()
      • 13.30.54 preTruncationLength()
      • 13.30.55 registerOutParam()
      • 13.30.56 setAutoCommit()
      • 13.30.57 setBatchErrorMode()
      • 13.30.58 setBDouble()
      • 13.30.59 setBfile()
      • 13.30.60 setBFloat()
      • 13.30.61 setBinaryStreamMode()
      • 13.30.62 setBlob()
      • 13.30.63 setBytes()
      • 13.30.64 setCharacterStreamMode()
      • 13.30.65 setCharSet()
      • 13.30.66 setCharSetUString()
      • 13.30.67 setClob()
      • 13.30.68 setDate()
      • 13.30.69 setDatabaseNCHARParam()
      • 13.30.70 setDataBuffer()
      • 13.30.71 setDataBufferArray()
      • 13.30.72 setDouble()
      • 13.30.73 setErrorOnNull()
      • 13.30.74 setErrorOnTruncate()
      • 13.30.75 setFloat()
      • 13.30.76 setInt()
      • 13.30.77 setIntervalDS()
      • 13.30.78 setIntervalYM()
      • 13.30.79 setMaxIterations()
      • 13.30.80 setMaxParamSize()
      • 13.30.81 setNull()
      • 13.30.82 setNumber()
      • 13.30.83 setObject()
      • 13.30.84 setPrefetchMemorySize()
      • 13.30.85 setPrefetchRowCount()
      • 13.30.86 setRef()
      • 13.30.87 setRowCountsOption()
      • 13.30.88 setRowid()
      • 13.30.89 setSQL()
      • 13.30.90 setSQLUString()
      • 13.30.91 setString()
      • 13.30.92 setTimestamp()
      • 13.30.93 setUInt()
      • 13.30.94 setUString()
      • 13.30.95 setVector()
      • 13.30.96 setVectorOfRefs()
      • 13.30.97 status()
    • 13.31 Stream Class
      • 13.31.1 readBuffer()
      • 13.31.2 readLastBuffer()
      • 13.31.3 writeBuffer()
      • 13.31.4 writeLastBuffer()
      • 13.31.5 status()
    • 13.32 Subscription Class
      • 13.32.1 Subscription()
      • 13.32.2 getCallbackContext()
      • 13.32.3 getDatabaseServersCount()
      • 13.32.4 getDatabaseServerNames()
      • 13.32.5 getNotifyCallback()
      • 13.32.6 getPayload()
      • 13.32.7 getSubscriptionName()
      • 13.32.8 getSubscriptionNamespace()
      • 13.32.9 getRecipientName()
      • 13.32.10 getPresentation()
      • 13.32.11 getProtocol()
      • 13.32.12 isNull()
      • 13.32.13 operator=()
      • 13.32.14 setCallbackContext()
      • 13.32.15 setDatabaseServerNames()
      • 13.32.16 setNotifyCallback()
      • 13.32.17 setNull()
      • 13.32.18 setPayload()
      • 13.32.19 setPresentation()
      • 13.32.20 setProtocol()
      • 13.32.21 setSubscriptionName()
      • 13.32.22 setSubscriptionNamespace()
      • 13.32.23 setRecipientName()
    • 13.33 Timestamp Class
      • 13.33.1 Timestamp()
      • 13.33.2 fromText()
      • 13.33.3 getDate()
      • 13.33.4 getTime()
      • 13.33.5 getTimeZoneOffset()
      • 13.33.6 intervalAdd()
      • 13.33.7 intervalSub()
      • 13.33.8 isNull()
      • 13.33.9 operator=()
      • 13.33.10 operator==()
      • 13.33.11 operator!=()
      • 13.33.12 operator>()
      • 13.33.13 operator>=()
      • 13.33.14 operator<()
      • 13.33.15 operator<=()
      • 13.33.16 setDate()
      • 13.33.17 setNull()
      • 13.33.18 setTime()
      • 13.33.19 setTimeZoneOffset()
      • 13.33.20 subDS()
      • 13.33.21 subYM()
      • 13.33.22 toText()
  • Index

Search

Print

Download

PDF for offline and print

  • Previous
  • Next
  1. List of Figures

List of Figures

  • 1-1        The OCCI Development Process
  • 4-1        Basic Object Operational Flow
  • 8-1        The OTT Utility with OCCI
Back to main content
  • About Oracle
  • Contact Us
  • Terms of Use and Privacy
  • Cookie Preferences
Copyright © 1999, 2019, Oracle and/or its affiliates.
  • Previous
  • Next
Video