OTL 4.0, Examples
Examples
- Oracle Call Interface 8 (OCI8)
- Oracle Call
Interface 8 (OCI8) for Oracle 8i that requires special
treatment
- Oracle
Call Interface 8i (OCI8i) with Unicode
- Oracle
Call Interface 9i (OCI9i) with Unicode
- Open DataBase Connectivity (ODBC)
- MyODBC for MySQL
- Example 78 (Simple
Insert/Select/Update, MyODBC 2.50)
- Example 79 ("Incompatible
datatypes in stream operation" exception, MyODBC 2.50)
- Example 80 (otl_datetime
container and datetime/date table columns, MyODBC 2.50)
- Example 81 (otl_long_string
container and LONGTEXT column, MyODBC 2.50)
- Example 82 (otl_long_string
container and LONGBLOB column, MyODBC 2.50)
- Example 83 (std::string and
STL-compliant stream iterators, MyODBC 2.50)
- Example 84
(otl_stream::describe_select() with a simple Select,
MyODBC 2.50)
- Example
225 (Simple Insert/Select/Update, MyODBC 3.50)
- Example 226 ("Incompatible
datatypes in stream operation" exception, MyODBC 3.50)
- Example 227 (otl_datetime
container and datetime/date table columns, MyODBC 3.50)
- Example 228 (otl_long_string
container and LONGTEXT column, MyODBC 3.50)
- Example 229 (otl_long_string
container and LONGBLOB column, MyODBC 3.50)
- Example 230 (std::string and
STL-compliant stream iterators, MyODBC 3.50)
- Example 231
(otl_stream::describe_select() with a simple Select,
MyODBC 3.50)
- DB2 Call Level
Interface (CLI)
PostgreSQL / PostgreSQL ODBC
- Miscellaneous
- Example 35 (otl_nocommit_stream
in Oracle 7)
- Example 36 (otl_nocommit_stream
in Oracle 8)
- Example 37 (otl_nocommit_stream
in ODBC)
- Examle 38 (otl_datetime in
Oracle 7)
- Examle 39 (otl_datetime in
Oracle 8)
- Examle 40 (otl_datetime in
ODBC)
- Example 41
(Insert/Update/Select with CLOB in Oracle 8)
- Example 42 (ODBC, OCI: LONG
==> CLOB. How to use OTL namespaces)
- Example 43 (Get Rows Processed
Count in Oracle 7)
- Example 44 (Get Rows Processed
Count in Oracle 8)
- Example 45 (Get Rows Processed
Count in ODBC)
- Example 46 ("Auto-commit every
SQL statement / commit-on-success" mode in Oracle 7)
- Example 47 ("Auto-commit every
SQL statement / commit-on-sucess" mode in Oracle 8)
- Example 48 ("Auto-commit every
SQL statement / commit-on-sucess" mode in ODBC)
- Example 49 (PL/SQL tables as
parameters, Oracle 7)
- Example 50 (PL/SQL tables as
parameters, Oracle 8)
- Example 51 (PL/SQL table of
DATEs as parameter, Oracle 7)
- Example 52 (PL/SQL table of
DATEs as parameter, Oracle 8)
- Example 53 (Datatype override
in SELECT, Oracle 7)
- Example 54 (Datatype override
in SELECT, Oracle 8)
- Example 55 (Datatype override
in SELECT, MS SQL Server)
- Example 56
(Insert/Update/Select with Oracle 8 CLOB in stream mode)
- Example 57
(Insert/Update/Select with Oracle 8 BLOB in stream mode)
- Example 58 (Using OTL/OCI7 in
Pro*C/C++ environment)
- Example 59 (Using OTL/OCI8 in
Pro*C/C++ environment)
- Example 60 (Using OTL/OCI8:
server_attach/detach and session_begin/end)
- Example 61 (Using OTL/OCI8:
server_attach/detach, session_begin/end, and
session_reopen)
- Example 65 (Simple
Insert/Select and otl_stream::clean() function for Oracle
7)
- Example 66 (Simple
Insert/Select and otl_stream::clean() function for Oracle
8/8i)
- Example 67 (Simple
Insert/Select and otl_stream::clean() function for
OTL/ODBC and MS SQL Server)
- Example 68 (Dynamically
allocated PL/SQL tables as parameters, Oracle 7)
- Example 69 (Dynamically
allocated PL/SQL tables as parameters, Oracle 8)
- Example 70 (Dynamically
allocated PL/SQL table of DATEs as parameter, Oracle 7)
- Example 71 (Dynamically
allocated PL/SQL table of DATEs as parameter, Oracle 8)
- Example 72 (STL std::strings,
ANSI C++ typecasts, Oracle 7)
- Example 73 (STL std::strings,
ANSI C++ typecasts, Oracle 8)
- Example 74 (STL std::strings,
ANSI C++ typecasts, MS SQL Server)
- Example 75 (STL-compliant OTL
stream iterators, Oracle 7)
- Example 76 (STL-compliant OTL
stream iterators, Oracle 8)
- Example 77 (STL-compliant
OTL/ODBC stream iterators, MS SQL Server)
- Example 85 (STL vector based
PL/SQL tables as parameters, Oracle 7)
- Example 86 (STL vector based
PL/SQL tables as parameters, Oracle 8)
- Example 87 (STL vector based
PL/SQL table of DATEs as parameter, Oracle 7)
- Example 88 (STL vector based
PL/SQL table of DATEs as parameter, Oracle 8)
- Example 97 (otl_value<T>,
Oracle 7)
- Example 98 (otl_value<T>,
Oracle 8/8i)
- Example 99 (otl_value<T>,
ODBC / MS SQL Server)
- Example 100
(otl_value<T>, DB2-CLI)
- Example 101 (#define
OTL_UNCAUGHT_EXCEPTION_ON, Oracle 7)
- Example 102 (#define
OTL_UNCAUGHT_EXCEPTION_ON, Oracle 8/8i)
- Example 103 (#define
OTL_UNCAUGHT_EXCEPTION_ON, ODBC / MS SQL Server)
- Example 104 (#define
OTL_EXTENDED_EXCEPTION, ODBC / MS SQL Server)
- Example 105 (OTL/ODBC and MS
SQL Server's GUIDs)
- Example 106 (OTL/ODBC and bulk
operations with Oracle's LONG)
- Example 107 (OTL/ODBC and bulk
operations with Oracle's CLOB)
- Example 108 (OTL/ODBC and bulk
operations with MS SQL Server's TEXT)
- Example 109 (OTL/DB2-CLI and
bulk operations with DB2's CLOB)
- Example 110 (Group data type
override in SELECT, Oracle 7)
- Example 111 (Group data type
override in SELECT, Oracle 8/8i)
- Example 112 (Group data type
override in SELECT, MS SQL Server)
- Example 113 (OTL stream
pooling, Oracle 8/8i)
- Example 114 (OTL stream
pooling, OTL/ODBC)
- Example 115 (OTL stream
pooling, DB2-CLI)
- Example 116
(otl_stream::set_flush(), Oracle 8/8i)
- Example 117
(otl_stream::set_flush(), OTL/ODBC)
- Example 118
(otl_stream::set_flush(), DB2-CLI)
- Example 119 (OTL_VALUE_TEMPLATE_ON,
OTL_USER_DEFINED_STRING_CLASS_ON, Oracle 8/8i)
- Example 120 (OTL_VALUE_TEMPLATE_ON,
OTL_USER_DEFINED_STRING_CLASS_ON, ODBC / MS
SQL Server)
- Example 121 (OTL_VALUE_TEMPLATE_ON,
OTL_USER_DEFINED_STRING_CLASS_ON, DB2-CLI)
- Example 122
(Insert/Update/Select with Oracle 8i CLOB in stream mode)
- Example 123
(Insert/Update/Select with Oracle 8i BLOB in stream mode)
- Example 124
(Insert/Update/Select with MS SQL Server TEXT in
stream mode)
- Example 125
(Insert/Update/Select with MS SQL Server IMAGE in
stream mode)
- Example 126
(Insert/Update/Select with DB2 CLOB in stream mode)
- Example 127
(Insert/Update/Select with DB2 BLOB in stream mode)
- Example 128
(Insert/Update/Select with MySQL LONGTEXT in stream
mode)
- Example 129
(Insert/Update/Select with MySQL LONGBLOB in stream
mode)
- Example 130 (Describe
otl_stream's bind variables for Oracle 8i)
- Example 131 (Describe
otl_stream's bind variables for MS SQL Server)
- Example 132 (Describe
otl_stream's bind variables for DB2)
- Example 147 (backward
compatibility with ODBC 2.5)
- Example 148 (otl_refcur_stream,
basic)
- Example 149
(otl_refcur_stream, stored procedure)
- Example 150
(otl_refcur_stream, PL/SQL tables and reference cursors as
parameters in stored procedure)
- Example 151 (otl_refcur_stream
and otl_lob_stream, used together)
- Example 152 (get_stream_type)
- Example 153
(create_stored_proc_call)
- Example 154
(set_transaction_isolation_level, DB2-CLI)
- Example 155
(set_transaction_isolation_level, ODBC, MS SQL)
- Example
156 (OTL/OCI8/9, otl_connect::cancel())
- Example
157
(external
logon, DB2-CLI)
- Example 158 (external logon,
ODBC, MS SQL)
- Example
159
(otl_stream::clean(),
cancelling SELECT's fetch sequence, Oracle 8i/9i )
- Example 160
(otl_stream::clean(), cancelling SELECT's fetch sequence,
MS SQL Server)
- Example 161
(otl_stream::clean(), cancelling SELECT's fetch sequence,
DB2 )
- Example 162
(otl_stream::clean(), cancelling REF CURSOR's fetch
sequence, Oracle 8i/9i)
- Example 163
(otl_stream::clean(), cancelling Result Set's fetch
sequence, MS SQL Server)
- Example 164
(otl_stream::clean(), cleaning the SELECT stream's error
flags, Oracle 8i/9i )
- Example 165
(otl_stream::clean(), cleaning the SELECT stream's error
flags, MS SQL Server )
- Example 166
(otl_stream::clean(), cleaning the SELECT stream's error
flags, DB2 )
- Example 167
(otl_stream::clean(), cleaning the REF CURSOR otl_stream's
error flags, Oracle 8i/9i )
- Example 168
(otl_stream::clean(), cleaning the Result Set stream's
error flags, MS SQL Server )
- Example 169 (#define's
OTL_DEFAULT_XXX_NULL_TO_VAL, Oracle 7/8/8i/9i)
- Example 170 (#define's
OTL_DEFAULT_XXX_NULL_TO_VAL, MS SQL Server)
- Example 171 (#define's
OTL_DEFAULT_XXX_NULL_TO_VAL, DB2)
- Example
172
(#define
OTL_ORA_TEXT_ON, Oracle 8/8i/9i)
- Example 173 (#define
OTL_ORA_TEXT_ON, Oracle 8/8i/9i)
- Example 202 (otl_datetime container
with TIMESTAMP values down to microseconds in DB2)
- Example 203 (otl_datetime
container with Datetime values down to milliseconds in MS
SQL Server)
- Example 204 (otl_datetime
container with TIMESTAMP values down to microseconds in
Oracle 9i)
- Example 205 (otl_exception, derived
from a base class, Oracle)
- Example 206 (otl_exception,
derived from a base class, MS SQL Server)
- Example 207 (otl_exception,
derived from a base class, DB2)
- Example
208 (lob_stream and SELECT INTO FOR UPDATE, Oracle)
- Example
209 (MS SQL Server and VARBINARY column)
- Example
210 (Oracle and RAW column)
- Example
211 (OTL_ADD_NULL_TERMINATOR_STRING_SIZE,Oracle)
- Example 212
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE,MS SQL Server)
- Example 213
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, DB2)
- Example 214
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, PostgreSQL)
- Example 215
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, MySQL)
- Example 216
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, FireBird Database)
- Example
217 (otl_stream::cancel() and DB2-CLI)
- Example 218
(otl_stream::cancel() and ODBC)
- Example
219 (otl_connect::change_password() and Oracle 8i/9i)
- Example
220 (std::string and LONGs, Oracle 7)
- Example 221 (std::string and
LONGs, Oracle 8/8i/9i)
- Example 222 (std::string and
CLOBs, Oracle 8/8i/9i)
- Example 223 (std::string and
TEXTs, MS SQL Server)
- Example 224 (std::string and
CLOBs, DB2)
- Example
232
(otl_stream::flush() and duplicate rows, Oracle 8, 8i, 9i)
- Example
233 (#define OTL_ORA_MAP_STRINGS_TO_CHARZ, Oracle 8, 8i,
9i)
- Example
234 (SQL statement label, Oracle 8,8i,9i)
- Example 235 (SQL statement
label, MS SQL Server)
- Example 236 (SQL statement
label, DB2)
- Example
237 (OTL/ODBC, accessing the system data dictionary via
ODBC functions, MS SQL Server)
- Example 238 (OTL/DB2-CLI,
accessing the system data dictionary via DB2 CLI
functions, DB2)
- Example 239 (OTL/ODBC, accessing
the system data dictionary via ODBC functions, MS SQL
Server)
- Example 240 (OTL/ODBC, accessing
the system data dictionary via ODBC functions, MS SQL
Server)
- Example 241 (otl_datetime container
with TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME
ZONE, Oracle 9i)
- Example 242
(64-bit integers (bigint), MS SQL Server, OTL/ODBC)
- Example 243 (64-bit integers
(bigint), DB2, OTL/DB2-CLI)
- Example
244 (user defined string class and LONGs, Oracle 7)
- Example 245 (user defined string
class and LONGs, Oracle 8/8i/9i)
- Example 246 (user defined string
class and CLOBs, Oracle 8/8i/9i)
- Example 247 (user defined string
class and TEXTs, MS SQL Server)
- Example 248 (user defined string
class and CLOBs, DB2)
- Example
249 (OTL tracing, Oracle 7)
- Example 250 (OTL tracing, Oracle
8/8i/9i)
- Example 251 (OTL tracing, ODBC,
MS SQL Server)
- Example 252 (OTL tracing, DB2
CLI)
- Example 253 (Explict bind variables
in SELECT statement column definitions, Oracle 7)
- Example 254 (Explict bind
variables in SELECT statement column definitions, Oracle
8/8i/9i)
- Example 255 (Explict bind variables
in SELECT statement column definitions, ODBC, MS SQL
Server)
- Example 256 (Explict bind
variables in SELECT statement column definitions, DB2)
- Example 257
(64-bit signed integers, Oracle 7)
- Example 258 (64-bit signed
integers, Oracle 8/8i/9i)
- Example 259
(#define OTL_THROWS_ON_SQL_SUCCESS_WITH_INFO, ODBC, MS SQL
Server)
- Example 260
(OTL stream read iterator, simple SELECT, Oracle)
- Example 261 (OTL stream read
iterator, reference cursor, Oracle)
- Example 262 (OTL stream read
iterator, simple SELECT, MS SQL / ODBC)
- Example 263 (OTL stream read
iterator, implicit result set, MS SQL / ODBC)
- Example 264 (OTL stream read
iterator, simple SELECT, DB2 CLI)
Prev NextContentsGo Home
Copyrigh6 © 1996-2015, Sergei Kuchin, email: skuchin@gmail.com, skuchin@gmail.com
.
Permission to use, copy, modify and redistribute this document
for any purpose is hereby granted without fee, provided that the
above copyright notice appear in all copies. THE SOFTWARE IS
PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH
REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE
LIABLE FOR ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL
DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE,
DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR
OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE
USE OR PERFORMANCE OF THIS SOFTWARE.