# OTL 4.0, Examples for Oracle 9i

The examples below work with Oracle 9i / OCI9i. In general, all of these examples should work with any Oracle version higher than Oracle 9.0, when OCI9i is enabled in OTL by setting #define OTL_ORA9I. Oracle normally provides decent backward compatibility, at least at the source code level. All examples for Oracle 7 and for Oracle 8/8i should work when OTL_ORA9I is enabled. In other words, in order to see more examples for Oracle 9i, take a closer look at the examples for Oracle 7 and Oracle 8/8i.

1. Example 241 (otl_datetime container with TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, Oracle 9i)
2. Example 260 (OTL stream read iterator, simple SELECT, Oracle)
3. Example 261 (OTL stream read iterator, reference cursor, Oracle)
4. Example 289 (Strict numeric type checking on SELECTs)

Prev Next Contents Go Home

Copyright © 1996, 2007, Sergei Kuchin, email: skuchin@ispwest.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.