📄 otl3_examples.htm
字号:
<li> <b><a href="otl3_ex113.htm">Example 113 (OTL stream
pooling, Oracle 8/8i)</a></b></li>
<li> <b><a href="otl3_ex114.htm">Example 114 (OTL stream pooling,
OTL/ODBC)</a></b></li>
<li> <b><a href="otl3_ex115.htm">Example 115 (OTL stream pooling,
DB2-CLI)</a></b></li>
<br>
<li> <b><a href="otl3_ex116.htm">Example 116
(otl_stream::set_flush(), Oracle 8/8i)</a></b></li>
<li> <b><a href="otl3_ex117.htm">Example 117
(otl_stream::set_flush(), OTL/ODBC)</a></b></li>
<li> <b><a href="otl3_ex118.htm">Example 118
(otl_stream::set_flush(), DB2-CLI)</a></b></li>
<br>
<li> <b><a href="otl3_ex119.htm">Example 119 (<font size="-1">OTL_VALUE_TEMPLATE_ON,
OTL_USER_DEFINED_STRING_CLASS_ON</font>, Oracle 8/8i)</a></b></li>
<li> <b><a href="otl3_ex120.htm">Example 120 (<font size="-1">OTL_VALUE_TEMPLATE_ON,
OTL_USER_DEFINED_STRING_CLASS_ON</font>, ODBC / MS SQL Server)</a></b></li>
<li> <b><a href="otl3_ex121.htm">Example 121 (<font size="-1">OTL_VALUE_TEMPLATE_ON,
OTL_USER_DEFINED_STRING_CLASS_ON</font>, DB2-CLI)</a></b></li>
<br>
<li> <b><a href="otl3_ex122.htm">Example 122
(Insert/Update/Select with Oracle 8i CLOB in stream mode)</a></b></li>
<li> <b><a href="otl3_ex123.htm">Example 123 (Insert/Update/Select
with Oracle 8i BLOB in stream mode)</a></b></li>
<li> <b><a href="otl3_ex124.htm">Example 124 (Insert/Update/Select
with MS SQL Server TEXT in stream mode)</a></b></li>
<li> <b><a href="otl3_ex125.htm">Example 125 (Insert/Update/Select
with MS SQL Server IMAGE in stream mode)</a></b></li>
<li> <b><a href="otl3_ex126.htm">Example 126 (Insert/Update/Select
with DB2 CLOB in stream mode)</a></b></li>
<li> <b><a href="otl3_ex127.htm">Example 127 (Insert/Update/Select
with DB2 BLOB in stream mode)</a></b></li>
<li> <b><a href="otl3_ex128.htm">Example 128 (Insert/Update/Select
with MySQL LONGTEXT in stream mode)</a></b></li>
<li> <b><a href="otl3_ex129.htm">Example 129 (Insert/Update/Select
with MySQL LONGBLOB in stream mode)</a></b></li>
<br>
<li> <b><a href="otl3_ex130.htm">Example 130 (Describe
otl_stream's bind variables for Oracle 8i)</a></b></li>
<li> <b><a href="otl3_ex131.htm">Example 131 (Describe
otl_stream's
bind variables for MS SQL Server)</a></b></li>
<li> <b><a href="otl3_ex132.htm">Example 132 (Describe
otl_stream's
bind variables for DB2)</a></b></li>
<br>
<li> <b><a href="otl4_ex147.htm">Example 147 (backward
compatibility with ODBC 2.5)</a></b></li>
<br>
<li> <a name="otl_refcur_stream"></a><b><a href="otl4_ex148.htm">Example
148 (otl_refcur_stream, basic)</a></b></li>
<li> <b><a href="otl4_ex149.htm">Example 149 (otl_refcur_stream,
stored procedure)</a></b></li>
<li> <b><a href="otl4_ex150.htm">Example 150 (otl_refcur_stream,
PL/SQL tables and reference cursors as parameters in stored procedure)</a></b></li>
<li> <b><a href="otl4_ex151.htm">Example 151 (otl_refcur_stream
and
otl_lob_stream, used together)</a></b></li>
<br>
<li> <b><a href="otl4_ex152.htm">Example 152 (get_stream_type)</a></b></li>
<br>
<li> <a name="create_stored_proc_call"></a><b><a
href="otl4_ex153.htm">Example 153 (create_stored_proc_call)</a></b></li>
<br>
<li> <a name="transaction_isolation_level"></a><b><a
href="otl4_ex154.htm">Example 154 (set_transaction_isolation_level,
DB2-CLI)</a></b></li>
<li> <b><a href="otl4_ex155.htm">Example 155
(set_transaction_isolation_level, ODBC, MS SQL)</a></b></li>
<br>
<li> <a name="cancel"></a><b><a href="otl4_ex156.htm">Example
156 (OTL/OCI8/9, otl_connect::cancel())</a></b></li>
<br>
<li> <a name="ext_logon_odbc"></a><b><a href="otl4_ex157.htm">Example
157 (external logon, DB2-CLI)</a></b></li>
<li> <b><a href="otl4_ex158.htm">Example 158 (external logon,
ODBC,
MS SQL)</a></b></li>
<br>
<li> <a name="clean_select"></a><b><a href="otl4_ex159.htm">Example
159 (otl_stream::clean(), cancelling SELECT's fetch sequence, Oracle
8i/9i )</a></b></li>
<li> <b><a href="otl4_ex160.htm">Example 160 (otl_stream::clean(),
cancelling SELECT's fetch sequence, MS SQL Server)</a></b></li>
<li> <b><a href="otl4_ex161.htm">Example 161 (otl_stream::clean(),
cancelling SELECT's fetch sequence, DB2 )</a></b></li>
<li> <b><a href="otl4_ex162.htm">Example 162 (otl_stream::clean(),
cancelling REF CURSOR's fetch sequence, Oracle 8i/9i)</a></b></li>
<li> <b><a href="otl4_ex163.htm">Example 163 (otl_stream::clean(),
cancelling Result Set's fetch sequence, MS SQL Server)</a></b></li>
<br>
<li> <b><a href="otl4_ex164.htm">Example 164
(otl_stream::clean(), cleaning the SELECT stream's error flags, Oracle
8i/9i )</a></b></li>
<li> <b><a href="otl4_ex165.htm">Example 165 (otl_stream::clean(),
cleaning the SELECT stream's error flags, MS SQL Server )</a></b></li>
<li> <b><a href="otl4_ex166.htm">Example 166 (otl_stream::clean(),
cleaning the SELECT stream's error flags, DB2 )</a></b></li>
<li> <b><a href="otl4_ex167.htm">Example 167 (otl_stream::clean(),
cleaning the REF CURSOR otl_stream's error flags, Oracle 8i/9i )</a></b></li>
<li> <b><a href="otl4_ex168.htm">Example 168 (otl_stream::clean(),
cleaning the Result Set stream's error flags, MS SQL Server )</a></b></li>
<br>
<li> <a name="OTL_DEFAULT_VALUE"></a><b><a href="otl4_ex169.htm">Example
169 (#define's OTL_DEFAULT_XXX_NULL_TO_VAL, Oracle 7/8/8i/9i)</a></b></li>
<li> <b><a href="otl4_ex170.htm">Example 170 (#define's
OTL_DEFAULT_XXX_NULL_TO_VAL, MS SQL Server)</a></b></li>
<li> <b><a href="otl4_ex171.htm">Example 171 (#define's
OTL_DEFAULT_XXX_NULL_TO_VAL, DB2)</a></b></li>
<br>
<li> <a name="OTL_ORA_TEXT_ON"></a><b><a href="otl4_ex172.htm">Example
172 (#define OTL_ORA_TEXT_ON, Oracle 8/8i/9i)</a></b></li>
<li> <b><a href="otl4_ex173.htm">Example 173 (#define
OTL_ORA_TEXT_ON, Oracle 8/8i/9i)</a></b></li>
<br>
<li> <a name="otl_datetime_fraction"></a><b><a
href="otl4_ex202.htm">Example 202 (otl_datetime container with
TIMESTAMP values down to microseconds in DB2)</a></b></li>
<li> <b><a href="otl4_ex203.htm">Example 203 (otl_datetime
container with Datetime values down to milliseconds in MS SQL Server)</a></b></li>
<li> <b><a href="otl4_ex204.htm">Example 204 (otl_datetime
container with TIMESTAMP values down to microseconds in Oracle 9i)</a></b></li>
<br>
<li> <a name="OTL_EXCEPTION_DERIVED_FROM"></a><b><a
href="otl4_ex205.htm">Example 205 (otl_exception, derived from a base
class, Oracle)</a></b></li>
<li> <b><a href="otl4_ex206.htm">Example 206 (otl_exception,
derived from a base class, MS SQL Server)</a></b></li>
<li> <b><a href="otl4_ex207.htm">Example 207 (otl_exception,
derived from a base class, DB2)</a></b></li>
<br>
<li> <a name="EX_208"></a><b><a href="otl4_ex208.htm">Example
208 (lob_stream and SELECT INTO FOR UPDATE, Oracle)</a></b></li>
<br>
<li> <a name="EX_209"></a><b><a href="otl4_ex209.htm">Example
209 (MS SQL Server and VARBINARY column)</a></b></li>
<br>
<li> <a name="EX_210"></a><b><a href="otl4_ex210.htm">Example
210 (Oracle and RAW column)</a></b></li>
<br>
<li> <a name="EX_211"></a><b><a href="otl4_ex211.htm">Example
211 (OTL_ADD_NULL_TERMINATOR_STRING_SIZE,Oracle)</a></b></li>
<li> <b><a href="otl4_ex212.htm">Example 212
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE,MS SQL Server)</a></b></li>
<li> <b><a href="otl4_ex213.htm">Example 213
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, DB2)</a></b></li>
<li> <b><a href="otl4_ex214.htm">Example 214
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, PostgreSQL)</a></b></li>
<li> <b><a href="otl4_ex215.htm">Example 215
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, MySQL)</a></b></li>
<li> <b><a href="otl4_ex216.htm">Example 216
(OTL_ADD_NULL_TERMINATOR_STRING_SIZE, FireBird Database)</a></b></li>
<br>
<li> <a name="EX_217"></a><b><a href="otl4_ex217.htm">Example
217 (otl_stream::cancel() and DB2-CLI)</a></b></li>
<li> <b><a href="otl4_ex218.htm">Example 218 (otl_stream::cancel()
and ODBC)</a></b></li>
<br>
<li> <a name="Ex_219"></a><b><a href="otl4_ex219.htm">Example
219 (otl_connect::change_password() and Oracle 8i/9i)</a></b></li>
<br>
<li> <a name="EX_220"></a><b><a href="otl4_ex220.htm">Example
220 (std::string and LONGs, Oracle 7)</a></b></li>
<li> <b><a href="otl4_ex221.htm">Example 221 (std::string and
LONGs, Oracle 8/8i/9i)</a></b></li>
<li> <b><a href="otl4_ex222.htm">Example 222 (std::string and
CLOBs, Oracle 8/8i/9i)</a></b></li>
<li> <b><a href="otl4_ex223.htm">Example 223 (std::string and
TEXTs, MS SQL Server)</a></b></li>
<li> <b><a href="otl4_ex224.htm">Example 224 (std::string and
CLOBs, DB2)</a></b></li>
<br>
<li> <a name="flush_oci"></a><b><a href="otl3_ex232.htm">Example
232 (otl_stream::flush() and duplicate rows, Oracle 8, 8i, 9i)</a></b></li>
<br>
<li> <a name="ex233"></a><b><a href="otl4_ex233.htm">Example
233 (#define OTL_ORA_MAP_STRINGS_TO_CHARZ, Oracle 8, 8i, 9i)</a></b></li>
<br>
<li> <a name="ex234"></a><b><a href="otl4_ex234.htm">Example
234 (SQL statement label, Oracle 8,8i,9i)</a></b></li>
<li> <b><a href="otl4_ex235.htm">Example 235 (SQL statement label,
MS SQL Server)</a></b></li>
<li> <b><a href="otl4_ex236.htm">Example 236 (SQL statement label,
DB2)</a></b><br>
<br>
<br>
</li>
<li> <a name="ex237"></a><b><a href="otl4_ex237.htm">Example 237
(OTL/ODBC, accessing the system data dictionary via ODBC functions, MS
SQL Server)</a></b></li>
<li> <b><a href="otl4_ex238.htm">Example 238 (OTL/DB2-CLI,
accessing the system data dictionary via DB2 CLI functions, DB2)</a></b></li>
<li><b><a href="otl4_ex239.htm">Example 239 (OTL/ODBC, accessing
the system data dictionary via ODBC functions, MS SQL Server)</a></b></li>
<li><b><a href="otl4_ex240.htm">Example 240 (OTL/ODBC, accessing
the system data dictionary via ODBC functions, MS SQL Server)<br>
<br>
</a></b></li>
<li><b><a href="otl4_ex241.htm" name="ex241"></a><a
href="otl4_ex241.htm">Example 241 (otl_datetime container with
TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, Oracle 9i)<br>
<br>
</a></b></li>
<li><b><a name="ex242"></a><a href="otl4_ex242.htm">Example
242 (64-bit integers (bigint), MS SQL Server, OTL/ODBC)</a></b></li>
<li><b><a href="otl4_ex243.htm">Example
243 (64-bit integers (bigint), DB2, OTL/DB2-CLI)<br>
<br>
</a></b></li>
<li> <a name="EX_244"></a><b><a href="otl4_ex244.htm">Example
244 (user defined string class and LONGs, Oracle 7)</a></b></li>
<li><b><a href="otl4_ex245.htm">Example
245 (user defined string class and LONGs, Oracle 8/8i/9i)</a></b></li>
<li><b><a href="otl4_ex246.htm">Example
246 (user defined string class and CLOBs, Oracle 8/8i/9i)</a></b></li>
<li><b><a href="otl4_ex247.htm">Example
247 (user defined string class and TEXTs, MS SQL Server)</a></b></li>
<li><b><a href="otl4_ex248.htm">Example
248 (user defined string class and CLOBs, DB2)<br>
<br>
</a></b></li>
<li> <a name="EX_249"></a><b><a href="otl4_ex249.htm">Example
249 (OTL tracing, Oracle 7)</a></b></li>
<li><b><a href="otl4_ex250.htm">Example
250 (OTL tracing, Oracle 8/8i/9i)</a></b></li>
<li><b><a href="otl4_ex251.htm">Example
251 (OTL tracing, ODBC, MS SQL Server)</a></b></li>
<li><b><a href="otl4_ex252.htm">Example
252 (OTL tracing, DB2 CLI)<br>
<br>
</a></b></li>
<li><b><a name="EX_253"></a></b><a href="otl4_ex252.htm"><b></b></a><b><a
href="otl4_ex253.htm">Example
253 (Explict bind variables in SELECT statement column definitions,
Oracle 7)</a></b></li>
<li><b><a href="otl4_ex254.htm">Example
254 (Explict bind variables in SELECT statement column definitions,
Oracle 8/8i/9i)</a></b></li>
<li><a href="otl4_ex252.htm"><b></b></a><b><a href="otl4_ex255.htm">Example
255 (Explict bind variables in SELECT statement column definitions,
ODBC, MS SQL Server)</a></b></li>
<li><b><a href="otl4_ex256.htm">Example
256 (Explict bind variables in SELECT statement column definitions, DB2)</a></b><br>
<b><a href="otl4_ex252.htm"> </a></b><br>
</li>
<li><b><a name="EX257"></a><a href="otl4_ex257.htm">Example
257 (64-bit signed integers,
Oracle 7)</a></b></li>
<li><b><a href="otl4_ex258.htm">Example
258 (64-bit signed integers,
Oracle 8/8i/9i)<br>
<br>
</a></b></li>
<li><b><a name="EX259"></a><a href="otl4_ex259.htm">Example
259 (#define OTL_THROWS_ON_SQL_SUCCESS_WITH_INFO, ODBC, MS SQL Server)<br>
<br>
</a></b></li>
<li><b><a name="ex260"></a><a href="otl4_ex260.htm">Example
260 (OTL stream read iterator, simple SELECT,
Oracle)</a></b></li>
<li><b><a href="otl4_ex261.htm">Example
261 (OTL stream read iterator, reference cursor,
Oracle)</a></b></li>
<li><b><a href="otl4_ex262.htm">Example
262 (OTL stream read iterator, simple SELECT, MS SQL / ODBC)</a></b></li>
<li><b><a href="otl4_ex263.htm">Example
263 (OTL stream read iterator, implicit result set, MS SQL / ODBC)</a></b></li>
<li><b><a href="otl4_ex264.htm">Example
264 (OTL stream read iterator, simple SELECT, DB2 CLI)</a></b></li>
</ul>
</ul>
<center>
<hr width="100%">
<p><a href="otl3_const_sql.htm">Prev</a> <a href="otl3_compile.htm">Next</a><a
href="otl3.htm">Contents</a><a href="home.htm">Go Home</a></p>
</center>
<p>Copyright © 1996, 2008, Sergei Kuchin, email: <a
href="mailto:skuchin@aceweb.com">skuchin@aceweb.com</a>, <a
href="mailto:skuchin@gmail.com">skuchin@gmail.com
<script language="JavaScript"><!-- hide from old browsers
var modDate = new Date(document.lastModified)
document.write("<i> Last Updated:</i> " + (modDate.getMonth()+1) + "/" +
modDate.getDate() + "/" + "0"+(modDate.getYear())%100+".");
//-->
</script></a>.</p>
<p><i>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.</i> </p>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-5456201-1");
pageTracker._trackPageview();
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -