Oracle C++ Call Interface Programmer’s Guide

Oracle C++ Call Interface Programmer’s Guide, 10g Release 1 (10.1). Part No. B10778-01. Copyright 1999, 2003 Oracle Corporation. All rights reserved. …

More PDF Content

Oracle C++ Call Interface Programmer\’s Guide

  • Send Us Your Comments … xvii
  • Preface… xix
  • Audience …
  • Organization…
  • Related Documentation …
  • Conventions…
  • Documentation Accessibility …
  • What\’s New in Oracle C++ Call lnterface? … xxvii
  • New Features for 10g Release 1 (10.1)…
  • Introduction to OCCI
  • Overview of OCCI…
  • Benefits of OCCI …
  • Building an OCCI Application …
  • Functionality of OCCI…
  • Procedural and Nonprocedural Elements …
  • Instant Client Feature…
  • Benefits of Instant Client …
  • Installing Instant Client …
  • Using Instant Client…
  • Patching Instant Client Shared Libraries on Unix …
  • Database Connection Names for Instant Client …
  • Environment Variables for OCCI Instant Client …
  • Processing of SQL Statements…
  • DDL Statements …
  • Control Statements …
  • DML SQL Statements…
  • Queries …
  • Overview of PL/SQL …
  • Special OCCI/SQL Terms …
  • Object Support …
  • Client-Side Object Cache …
  • Runtime Environment for Objects…
  • Associative and Navigational Interfaces …
  • Metadata Class …
  • Object Type Translator Utility …
  • Relational Programming
  • Connecting to a Database …
  • Creating and Terminating an Environment …
  • Opening and Closing a Connection …
  • Connection Pooling …
  • Creating a Connection Pool…
  • Stateless Connection Pooling …
  • Executing SQL DDL and DML Statements …
  • Creating a Statement Object …
  • Creating a Statement Object to Execute SQL Commands …
  • Reusing a Statement Object…
  • Terminating a Statement Object …
  • Types of SQL Statements in the OCCI Environment …
  • Standard Statements…
  • Parameterized Statements …
  • Callable Statements …
  • Streamed Reads and Writes …
  • Modifying Rows Iteratively …
  • Executing SQL Queries…
  • Result Set…
  • Specifying the Query…
  • Optimizing Performance by Setting Prefetch Count…
  • Executing Statements Dynamically…
  • Status Definitions…
  • Committing a Transaction …
  • Statement Caching…
  • Exception Handling…
  • Null and Truncated Data…
  • Advanced Relational Techniques …
  • Sharing Connections …
  • Optimizing Performance …
  • Object Programming
  • Overview of Object Programming …
  • Working with Objects in OCCI …
  • Persistent Objects…
  • Transient Objects …
  • Values …
  • Representing Objects in C++ Applications…
  • Creating Persistent and Transient Objects …
  • Creating Object Representations using the OTT Utility …
  • Developing an OCCI Object Application…
  • Basic Object Program Structure…
  • Basic Object Operational Flow…
  • Migrating C++ Applications Using OCCI …
  • Steps for Migration…
  • Overview of Associative Access …
  • Using SQL to Access Objects …
  • Inserting and Modifying Values …
  • Overview of Navigational Access…
  • Retrieving an Object Reference (REF) from the Database Server …
  • Pinning an Object…
  • Manipulating Object Attributes…
  • Marking Objects and Flushing Changes …
  • Marking an Object as Modified (Dirty) …
  • Recording Changes in the Database …
  • Garbage Collection in the Object Cache …
  • Transactional Consistency of References …
  • Overview of Complex Object Retrieval …
  • Retrieving Complex Objects…
  • Prefetching Complex Objects …
  • Working with Collections …
  • Fetching Embedded Objects…
  • Nullness…
  • Using Object References …
  • Deleting Objects from the Database …
  • Type Inheritance…
  • Substitutability …
  • NOT INSTANTIABLE Types and Methods …
  • OCCI Support for Type Inheritance…
  • OTT Support for Type Inheritance…
  • A Sample OCCI Application …
  • Datatypes
  • Overview of Oracle Datatypes …
  • OCCI Type and Data Conversion …
  • Internal Datatypes …
  • Character Strings and Byte Arrays…
  • Universal Rowid (UROWID) …
  • External Datatypes …
  • Description of External Datatypes …
  • Data Conversions …
  • Data Conversions for LOB Datatypes…
  • Data Conversions for Date, Timestamp, and Interval Datatypes…
  • Metadata
  • Overview of Metadata…
  • Notes on Types and Attributes…
  • Describing Database Metadata …
  • Metadata Code Examples …
  • Attribute Reference …
  • Parameter Attributes…
  • Table and View Attributes …
  • Procedure, Function, and Subprogram Attributes …
  • Package Attributes…
  • Type Attributes …
  • Type Attribute Attributes…
  • Type Method Attributes …
  • Collection Attributes …
  • Synonym Attributes …
  • Sequence Attributes …
  • Column Attributes…
  • Argument and Result Attributes…
  • List Attributes …
  • Schema Attributes …
  • Database Attributes…
  • Object Type Translator Utility
  • Overview of the Object Type Translator Utility …
  • Using the OTT Utility …
  • Creating Types in the Database …
  • Invoking the OTT Utility …
  • Specifying OTT Parameters …
  • Invoking the OTT Utility on the Command Line …
  • OTT Utility Parameters…
  • Where OTT Parameters Can Appear…
  • File Name Comparison Restriction…
  • Using the INTYPE File…
  • Overview of the INTYPE File …
  • Structure of the INTYPE File…
  • Nested #include File Generation …
  • OTT Utility Datatype Mappings …
  • Default Name Mapping…
  • Overview of the OUTTYPE File…
  • The OTT Utility and OCCI Applications …
  • C++ Classes Generated by the OTT Utility…
  • Map Registry Function…
  • Extending C++ Classes …
  • Carrying Forward User Added Code …
  • Properties of OTT Markers…
  • Using OTT Markers …
  • Globalization and Unicode Support
  • Overview of Globalization and Unicode Support …
  • Specifying Charactersets …
  • Datatypes for Globalization and Unicode Support …
  • UString Datatype …
  • Multibyte and UTF16 data …
  • CLOB and NCLOB Datatypes…
  • Objects and OTT Support …
  • Oracle Streams Advanced Queuing
  • Overview of Oracle Streams Advanced Queuing …
  • AQ Implementation in OCCI …
  • Message …
  • Agent …
  • Producer …
  • Consumer…
  • Listener …
  • Subscription …
  • Creating Messages …
  • Message Payloads …
  • Message Properties …
  • Enqueuing Messages…
  • Dequeuing Messages …
  • Dequeuing Options …
  • Listening for Messages …
  • Registering for Notification…
  • Publish-Subscribe Notifications…
  • Notification Callback…
  • Message Format Transformation … 8-15
  • Oracle XA Library
  • Application Development with XA and OCCI… 9-1
  • APIs for XA Support … 9-2
  • OCCI Application Programming Interface
  • OCCI Classes and Methods … 10-2
  • Agent Class … 10-10
  • AnyData Class … 10-14
  • Bfile Class… 10-26
  • Blob Class… 10-35
  • Bytes Class… 10-45
  • Clob Class… 10-48
  • Connection Class … 10-61
  • ConnectionPool Class … 10-72
  • Consumer Class… 10-78
  • Date Class… 10-89
  • Environment Class… 10-102
  • IntervalDS Class … 10-118
  • IntervalYM Class … 10-131
  • Listener Class… 10-142
  • Map Class … 10-145
  • Message Class… 10-147
  • MetaData Class… 10-158
  • NotifyResult Class… 10-166
  • Number Class … 10-168
  • PObject Class… 10-194
  • Producer Class … 10-201
  • Ref Class … 10-207
  • RefAny Class … 10-214
  • ResultSet Class … 10-219
  • SQLException Class … 10-245
  • StatelessConnectionPool Class … 10-249
  • Statement Class … 10-260
  • Stream Class… 10-316
  • Subscription Class … 10-319
  • Timestamp Class … 10-327
  • Index
Download Oracle C++ Call Interface Programmer's Guide pdf from download.oracle.com, 600 pages, 8753.77KB.
Related Books

Leave a Reply