Programmer's Guide to the Pro*C/C++ Precompiler Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents



Index


  • deadlock
  • DECIMAL datatype
  • declaration
  • declarative SQL statements
  • DECLARE CURSOR command
  • DECLARE CURSOR statement
  • DECLARE DATABASE directive
  • Declare Section, when MODE=ANSI [2]
  • DECLARE statement
  • DECLARE STATEMENT command
  • DECLARE STATEMENT statement
  • DECLARE statement
  • DECLARE TABLE command
  • DECLARE TABLE statement
  • DEF_SQLCODE, precompiler option
  • default connections
  • default database
  • DEFINE option, used in application migration
  • DEFINE
  • DELETE CASCADE
  • DELETE command
  • DELETE statement
  • delimiters, C versus SQL
  • DEPT table
  • DESCRIBE BIND VARIABLES statement, use in dynamic SQL method 4
  • DESCRIBE command
  • DESCRIBE SELECT LIST statement, use in dynamic SQL method 4
  • DESCRIBE statement, use in dynamic SQL method 4
  • descriptor, naming
  • descriptors
  • dimension, of host arrays
  • DISPLAY datatype
  • distributed processing
  • distributed transactions
  • DO action
  • DO option, of WHENEVER command
  • dots
  • DTP model
  • dummy host variables, placeholders
  • dynamic PL/SQL
  • dynamic SQL
  • dynamic SQL method 1
  • dynamic SQL method 2
  • dynamic SQL method 3
  • dynamic SQL method 4
  • dynamic SQL methods, overview of
  • dynamic SQL statements
  • dynamic SQL
  • ellipsis
  • embedded SQL
  • embedded PL/SQL
  • embedded SQL statement, referencing indicator variables
  • embedded SQL statements
  • embedded SQL
  • embedding, PL/SQL blocks in Oracle7 precompiler programs
  • EMP table
  • ENABLE THREADS command [2]
  • enabling, threads [2]
  • encoding scheme
  • enqueues, locking
  • entering options [2]
  • equivalencing of datatypes
  • equivalencing
  • error detection, error reporting
  • error handling
  • error messages
  • error reporting
  • ERRORS, precompiler option
  • exception, PL/SQL, definition of
  • EXEC ORACLE DEFINE statement
  • EXEC ORACLE ELSE statement
  • EXEC ORACLE ENDIF statement
  • EXEC ORACLE IFDEF statement
  • EXEC ORACLE IFNDEF statement
  • EXEC ORACLE OPTION, used to set option values in a file
  • EXEC ORACLE statement
  • EXEC SQL clause
  • EXEC SQL INCLUDE, contrasted with #include
  • EXEC TOOLS statements
  • EXEC TOOLS
  • executable SQL statements
  • EXECUTE command [2]
  • EXECUTE IMMEDIATE command
  • EXECUTE IMMEDIATE statement
  • EXECUTE statement, use in dynamic SQL method 2
  • execution of statements
  • execution plan [2]
  • EXPLAIN PLAN statement
  • explicit connections
  • external datatypes
  • F variable in SQLDA
  • FETCH command
  • FETCH statement
  • fetching in batches, batch fetch
  • fetching, rows from cursors
  • FIPS flagger
  • FIPS, precompiler option
  • flags, warning flags
  • FLOAT datatype
  • FOR clause
  • FOR UPDATE OF clause
  • FORCE clause
  • forward references, why not allowed
  • free() function
  • freeing, thread context [2]
  • full scan, description of
  • function prototype, definition of
  • functions, cannot serve as host variables
  • GENXTB form
  • GENXTB utility
  • GOTO action
  • GOTO option, of WHENEVER command
  • guidelines
  • heap, definition of
  • hints
  • HOLD_CURSOR option, of ORACLE Precompilers
  • HOLD_CURSOR
  • host arrays
  • host language, definition of
  • host program, definition of
  • host structures
  • host variables
  • I variable in SQLDA
  • IAF GET statement
  • IAF PUT statement
  • IAP in SQL*Forms, purpose of
  • identifier
  • identifiers, ORACLE, how to form
  • implicit connections
  • IN OUT parameter mode
  • IN parameter mode
  • in-doubt transaction
  • INAME, precompiler option
  • INCLUDE
  • indexes, using to improve performance
  • indicator arrays
  • INDICATOR keyword
  • indicator variables
  • input host variables
  • INSERT command
  • insert of no rows, cause of
  • INSERT statement
  • inserting, rows into tables and views
  • INTEGER datatype
  • interface
  • internal datatypes
  • INTO clause
  • invalid use, of precompiler preprocessor
  • IRECLEN, precompiler option
  • IS NULL operator, for testing nulls
  • ISO, compliance
  • joins, restriction on
  • keywords
  • L variable in SQLDA
  • label name, maximum length of
  • LINES, precompiler option
  • link, database link
  • linking
  • LNAME, precompiler option
  • LNPROC, VMS link script
  • location transparency, how provided
  • LOCK TABLE statement
  • locking
  • lock, released by ROLLBACK statement
  • logging on
  • LONG datatype
  • LONG RAW datatype
  • LONG VARCHAR
  • LONG VARRAW datatype
  • LRECLEN, precompiler option
  • LTYPE, precompiler option
  • lvalue
  • M variable in SQLDA
  • malloc()
  • MAXLITERAL
  • MAXOPENCURSORS
  • migration
  • MLSLABEL datatype
  • MODE, precompiler option [2]
  • modes, parameter
  • multi-threaded applications
  • multibyte character sets
  • N variable in SQLDA
  • namespaces, reserved by Oracle
  • naming
  • national language support (NLS)
  • native interface
  • NATIVE, value of DBMS option
  • nesting, of host structs not permitted
  • network
  • NIST, compliance
  • NLS (national language support)
  • NLS parameter
  • NLS_CHAR, precompiler option
  • NLS_LOCAL, precompiler option
  • node
  • NOT FOUND condition
  • notation
  • NOWAIT parameter
  • null-terminated string
  • nulls
  • NUMBER datatype
  • numeric expressions, cannot serve as host variables
  • NVL function, for retrieving null values
  • obsolete options
  • OCI calls
  • OCI onblon() call, not used to connect
  • OCI orlon() call, not used to connect
  • ocidfn.h
  • ONAME option, usage notes for
  • ONAME, precompiler option
  • OPEN command
  • OPEN statement
  • OPEN_CURSORS parameter
  • open, a cursor variable
  • opening, cursors
  • operators
  • optimization approach
  • optimizer hints
  • ORACA
  • ORACA option, usage notes for
  • ORACABC component
  • ORACA
  • ORACAID component
  • ORACA
  • ORACCHF flag
  • Oracle Call Interface
  • Oracle Communications Area
  • ORACLE identifiers, how to form
  • Oracle keywords
  • Oracle namespaces
  • Oracle reserved words
  • Oracle
  • ORACOC component
  • ORADBGF flag
  • ORAHCHF flag
  • ORAHOC component
  • ORAMOC component
  • ORANEX component
  • ORANOR component
  • ORANPR component
  • ORASFNMC component
  • ORASFNML component
  • ORASLNR component
  • ORASTXTC component
  • ORASTXTF flag
  • ORASTXTL component
  • ORECLEN, precompiler option
  • OUT parameter mode
  • output host variables
  • overhead, reducing
  • PAGELEN, precompiler option
  • parameter modes
  • parent cursor
  • parse error offset
  • parse
  • parsing dynamic statements, PREPARE command
  • password, defining
  • performance
  • PL/SQL
  • PL/SQL blocks, embedded in Oracle7 precompiler programs
  • PL/SQL reserved words
  • PL/SQL
  • placeholders, duplicate [2]
  • pointer variables
  • pointer
  • precision
  • precompilation
  • precompilation unit [2]
  • precompilation, conditional
  • precompiler directives, CONTEXT USE [2]
  • precompiler options
  • precompiler, Oracle precompilers
  • precompiling, use of INCLUDE option
  • PREPARE command
  • PREPARE statement
  • preprocessor directives
  • preprocessor, invalid uses of
  • private SQL area
  • Pro*C Precompiler
  • Pro*C preprocessor, restrictions on
  • procedural database extension
  • program termination, normal versus abnormal
  • Program Global Area (PGA)
  • programming guidelines
  • queries
  • RAW datatype
  • read consistency, definition of
  • READ ONLY parameter, in SET TRANSACTION statement
  • read-only transactions
  • REBIND option, obsolete options
  • record
  • REENTRANT option, obsolete options
  • reentrant, definition of
  • REFERENCE clause, in TYPE statement
  • reference, to indicator variables
  • referencing, of host arrays [2]
  • RELEASE option
  • RELEASE_CURSOR option
  • RELEASE_CURSOR
  • release, migrating an application to release 2.1
  • remote database, declaration of
  • reserved words
  • resource manager
  • restrictions
  • retrieving rows from a table, embedded SQL
  • return codes, user exits
  • roll back
  • ROLLBACK command
  • rollback segment, function of
  • ROLLBACK statement
  • rollbacks
  • rolling back, transactions
  • row locks
  • ROWID
  • rows-processed count
  • rows
  • runtime context models
  • S variable in SQLDA
  • sample database tables
  • sample programs
  • SAVEPOINT command
  • SAVEPOINT statement
  • SAVEPOINTS parameter
  • savepoints
  • scale
  • scope
  • search condition
  • SELECT command
  • select descriptor [2] [3]
  • select list
  • select SQLDA, purpose of
  • SELECT statement
  • SELECT_ERROR, precompiler option [2]
  • semantic checking
  • separate precompilation
  • server, integration with PL/SQL
  • session, definition of
  • sessions, beginning
  • SET clause
  • SET TRANSACTION statement
  • snapshot
  • SQL Communications Area
  • SQL Descriptor Area, SQLDA [2]
  • SQL statements
  • SQL*Forms
  • SQL*Net
  • SQL*Plus
  • SQL_CURSOR
  • sqlald() function
  • sqlaldt() function
  • SQL, benefits of
  • SQLCA [2]
  • sqlca.h
  • SQLCABC component
  • SQLCA
  • SQLCAID component
  • SQLCA
  • sqlcdat() function
  • SQLCHECK option [2]
  • SQLCHECK, precompiler option
  • sqlclu() function
  • sqlclut() function
  • SQLCODE
  • SQLCODE status variable
  • sqlcode, component in SQLCA [2]
  • sqlcpr.h
  • sqlcurt() function
  • sqlda.h
  • SQLDA
  • SQL, Embedded SQL
  • sqlerrd[2] component [2]
  • sqlerrd, component [2]
  • sqlerrmc component
  • sqlerrm, component in the SQLCA
  • sqlerrml component
  • SQLERROR condition
  • SQLERROR, WHENEVER command condition
  • sqlglm()
  • sqlglm() function [2]
  • sqlglmt() function
  • sqlgls() function
  • sqlglst() function
  • SQLIEM function
  • SQL, in multi-threaded applications
  • sqlld2() function
  • sqlld2t() function
  • sqllda() function
  • sqlldat() function
  • SQLLIB
  • SQL
  • sqlnul() function
  • sqlnult() function
  • sqlpr2() function
  • sqlpr2t() function
  • sqlprc() function [2]
  • sqlprct() function
  • SQLSTATE
  • SQL, summary of commands
  • sqlvcp() function
  • sqlvcpt() function
  • sqlwarn, flag [2] [3]
  • SQLWARNING condition
  • SQLWARNING, WHENEVER command condition
  • square brackets
  • statement-level rollback
  • status codes, meaning of
  • status variables
  • STOP action
  • STOP option, of WHENEVER command
  • stored procedures, program example
  • stored subprograms
  • STRING datatype
  • string host variables, declaring
  • struct pointers as host variables
  • structs, as host variables
  • structures
  • subqueries
  • syntax checking
  • syntax diagram
  • syntax, embedded SQL [2]
  • SYS_INCLUDE, precompiler option [2]
  • system configuration file
  • system failure, effect on transactions
  • System Global Area (SGA)
  • system header files, specifying the location of
  • system-specific Oracle documentation [2] [3] [4] [5] [6] [7] [8] [9] [10]
  • system-specific reference [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] [13]
  • T variable in SQLDA
  • table locks
  • tables
  • terminal, encoding scheme
  • termination, program, normal versus abnormal
  • TEST, precompiler option
  • thread [2] [3] [4]
  • threads, allocating context [2]
  • TO clause, of ROLLBACK command
  • TO SAVEPOINT clause
  • Toolset, Oracle
  • trace facility
  • transaction processing monitor
  • transaction processing
  • transactions
  • truncated values, detecting [2]
  • truncation error, when generated
  • tuning, performance
  • two-task, linking
  • TYPE command
  • TYPE statement, REFERENCE clause in
  • unconditional deletion, definition of
  • undo a transaction
  • unions
  • UNIX, linking a Pro*C application under
  • UNSAFE_NULL option
  • UNSAFE_NULL, precompiler option [2] [3]
  • UNSIGNED datatype
  • UPDATE CASCADE
  • UPDATE command
  • UPDATE statement
  • updating, rows in tables and views
  • upgrading, an application to Pro*C 2.1
  • user configuration file
  • user exits
  • user session, definition of
  • user-defined type equivalencing
  • user-defined record
  • user-defined stored function, used in WHERE clause
  • USERID option
  • USERID, precompiler option
  • username, defining
  • use, thread context [2]
  • USING clause
  • using dbstring, SQL*Net database id specification
  • V variable in SQLDA
  • V6_CHAR, value of DBMS option
  • V6, value of DBMS option
  • V7, value of DBMS option
  • VALUES clause
  • VAR command
  • VAR statement, syntax for [2]
  • VARCHAR datatype
  • VARCHAR pseudotype, requirements for using with PL/SQL
  • VARCHAR variables
  • VARCHAR2 datatype [2]
  • VARCHAR
  • variables
  • VARNUM datatype
  • VARRAW datatype
  • vertical bar
  • views
  • VMS, linking a precompiler application
  • warning flags, use in error reporting
  • WHENEVER command
  • WHENEVER statement
  • WHERE clause
  • WHERE CURRENT OF clause, CURRENT OF clause
  • WORK option
  • X variable in SQLDA
  • X/Open
  • XA interface
  • XREF, precompiler option
  • Y variable in SQLDA
  • Z variable in SQLDA

    Oracle
    Copyright © 1997 Oracle Corporation.
    All Rights Reserved.
    Go to Product Documentation Library
    Library
    Go to books for this product
    Product
    Go to Contents for this book
    Contents