📄 index.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"><title>OCILIB (C Driver for Oracle): Main Page</title><link href="doxygen.css" rel="stylesheet" type="text/css"><link href="tabs.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.5.4 --><div class="tabs"> <ul> <li class="current"><a href="index.html"><span>Main Page</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li><a href="annotated.html"><span>Data Structures</span></a></li> <li><a href="files.html"><span>Files</span></a></li> </ul></div><h1>OCILIB (C Driver for Oracle) Documentation</h1><p><h3 align="center">3.2.0 </h3><div align="center"><img src="logo-160x120.png" alt="logo-160x120.png"></div><h2><a class="anchor" name="s_intro">Introduction</a></h2>OCILIB is an open source and portable Oracle Driver that delivers really fast and reliable access to Oracle databases.<p>The OCILIB library :<p><ul><li>offers a rich, full featured and easy to use API</li><li>runs on all Oracle platforms</li><li>is written in pure ISO C code with native ISO C Unicode support</li><li>encapsulates OCI (Oracle Call Interface)</li><li>is the most complete available OCI wrapper</li></ul><h2><a class="anchor" name="s_version">Version information</a></h2><b>Current version : 3.2.0 (2009-04-20)</b><h2><a class="anchor" name="s_feats">Main features</a></h2><ul><li>Data binding</li><li>Integrated smart define and fetch mechanisms</li><li>Full Unicode support on all platforms</li><li>Support for all Oracle SQL and PL/SQL datatypes</li><li>Multi row fetching</li><li>Binding array Interface for fast and massive bulk operations</li><li>Reusable Statements</li><li>Scrollable statements</li><li>Connection Pooling</li><li>Global Transactions</li><li>Returning DML feature support</li><li>ROWIDs support</li><li>Named Types (Object types) support (User or Built-in)</li><li>Collections (Varrays and Nested tables)</li><li>Ref cursors</li><li>Full PL/SQL support (blocks, cursors, Index by Tables and Nested tables)</li><li>LOB (BLOBs/ FILEs)</li><li>Supports lobs > 4Go</li><li>Supports Direct Path API</li><li>Long datatype (piecewise operations)</li><li>Provides "All in one" Formatted functions (printf's like)</li><li>Smallest possible memory usage</li><li>Date/time management</li><li>Timestamps and Intervals support</li><li>Error handling</li><li>Thread contextual error management</li><li>Describe database schema objects</li><li>Access columns by index or name</li><li>Hash tables API</li><li>Portable Threads and mutexes API</li><li>Supports static / shared oracle linkage</li><li>Support runtime loading (no OCI libs required at compile / time)</li></ul><h2><a class="anchor" name="s_down">Download</a></h2>Get OCILIB from <a href="http://orclib.sourceforge.net">OCILIB Project page</a> at Sourceforge Website<h2><a class="anchor" name="s_author">Author</a></h2>OCILIB is developed by <a href="mailto:vince.rogier@gmail.com">Vincent Rogier</a><h2><a class="anchor" name="s_changelog">ChangeLog</a></h2><div class="fragment"><pre class="fragment">2009-04-20 Version 3.2.0 Vincent Rogier vince.rogier@gmail.com * Added support <span class="keywordflow">for</span> Direct Path Loading - See section in the documentation (page <module>, section <Direct Path loading>) - Added handle <a class="code" href="struct_o_c_i___dir_path.html" title="OCILIB encapsulation of OCI Direct Path handle.">OCI_DirPath</a> - Added <a class="code" href="group__g__dirpath.html#g64dd9756aa24ead3addabf50db0d6f16" title="Create a direct path object.">OCI_DirPathCreate</a>() - Added <a class="code" href="group__g__dirpath.html#g024f04e69293349e3882b2f367a03ed6" title="Free an OCI_DirPath handle.">OCI_DirPathFree</a>() - Added <a class="code" href="group__g__dirpath.html#g5811ff326acc9c863110d23c739aa4e7" title="Describe a column to load into the given table.">OCI_DirPathSetColumn</a>() - Added <a class="code" href="group__g__dirpath.html#g31aae5239710847d43b90166fedf0419" title="Prepares the OCI direct path load interface before any rows can be converted or loaded...">OCI_DirPathPrepare</a>() - Added <a class="code" href="group__g__dirpath.html#gaadd5e79891c24d0f9c99ed96e5fe608" title="Set the value of the given row/column array entry.">OCI_DirPathSetEntry</a>() - Added <a class="code" href="group__g__dirpath.html#g8dd680e9664028af035e773275e5ab76" title="Convert user provided data to a direct path stream format.">OCI_DirPathConvert</a>() - Added <a class="code" href="group__g__dirpath.html#g0c816466d046a3d8c179f779e273f456" title="Loads the data converted to direct path stream format.">OCI_DirPathLoad</a>() - Added <a class="code" href="group__g__dirpath.html#g2efc984ff0647d3a3c4b29f7e9ec37e2" title="Reset internal arrays and streams to prepare another load.">OCI_DirPathReset</a>() - Added <a class="code" href="group__g__dirpath.html#g7c80a8db7ef79e4693ac0e770bb2018f" title="Terminate a direct path operation and commit changes into the database.">OCI_DirPathFinish</a>() - Added <a class="code" href="group__g__dirpath.html#g382a1cbd623aa97ca69fed7b26923d61" title="Terminate a direct path operation without committing changes.">OCI_DirPathAbort</a>() - Added <a class="code" href="group__g__dirpath.html#g39b093ea31cdee551552e35df8167a22" title="Execute a data savepoint (server side).">OCI_DirPathSave</a>() - Added <a class="code" href="group__g__dirpath.html#gfe3add5d1595fbabab7e197ce26f9a67" title="Flushes a partially loaded row from server.">OCI_DirPathFlushRow</a>() - Added <a class="code" href="group__g__dirpath.html#g0062665eba53e0b62be65d4f0ee0df55" title="Set the current number of rows to convert and load.">OCI_DirPathSetCurrentRows</a>() - Added <a class="code" href="group__g__dirpath.html#gfb5fd763a6a181a8aae27db13ca28735" title="Return the current number of rows used in the OCILIB internal arrays of rows.">OCI_DirPathGetCurrentRows</a>() - Added <a class="code" href="group__g__dirpath.html#g2ff812128f1604615f186aa8bdf8269d" title="Return the maximum number of rows allocated in the OCI and OCILIB internal arrays...">OCI_DirPathGetMaxRows</a>() - Added <a class="code" href="group__g__dirpath.html#g0520cc694864d2eddba4857aaf77b2f6" title="Set the default date format string for input conversion.">OCI_DirPathSetDateFormat</a>() - Added <a class="code" href="group__g__dirpath.html#gfab72b4c04bd2c5d3c850f58f5b22fd2" title="Set the parallel loading mode.">OCI_DirPathSetParallel</a>() - Added <a class="code" href="group__g__dirpath.html#g59a031e1515afd31654105071dc7e371" title="Set the logging mode for the loading operation.">OCI_DirPathSetNoLog</a>() - Added <a class="code" href="group__g__dirpath.html#ga0976d38ccf4d6f09657115ad6e47880" title="Set number of elements in the date cache.">OCI_DirPathSetCacheSize</a>() - Added <a class="code" href="group__g__dirpath.html#ge25febeb9086f1604743fbf54a4cf677" title="Set the size of the internal stream transfer buffer.">OCI_DirPathSetBufferSize</a>() - Added <a class="code" href="group__g__dirpath.html#gade590aadb20d903770d9dc9c82ddb0c" title="return the number of rows successfully processed during in the last conversion or...">OCI_DirPathGetAffectedRows</a>() - Added <a class="code" href="group__g__dirpath.html#gffb07d43825826b0c9af060ee52fc3e0" title="Return the number of rows successfully loaded into the database so far.">OCI_DirPathGetRowCount</a>() - Added <a class="code" href="group__g__dirpath.html#g957a4d36b54166195cebeca461ddc7c4" title="Return the column index which caused an error during data conversion.">OCI_DirPathGetErrorColumn</a>() - Added <a class="code" href="group__g__dirpath.html#g29e788b14e1e9ecd691c101c38f9e118" title="Return the row index which caused an error during data conversion.">OCI_DirPathGetErrorRow</a>() - added <a class="code" href="group__g__handles.html#gdc8c52919edd87057b8b1d0bf54344c5" title="Return OCI DirectPath Stream handle (OCIDirPathStream *) of an OCILIB OCI_DirPath...">OCI_HandleGetDirPathStream</a>() - added <a class="code" href="group__g__handles.html#ga73f88244e2242363b3694ffa19fa6f4" title="Return OCI DirectPath Column array handle (OCIDirPathColArray *) of an OCILIB OCI_DirPath...">OCI_HandleGetDirPathColArray</a>() - added <a class="code" href="group__g__handles.html#gd5024a0096e3cfd751cd94d49d195e53" title="Return OCI DirectPath Context handle (OCIDirPathCtx *) of an OCILIB OCI_DirPath object...">OCI_HandleGetDirPathCtx</a>() - Added Exception type OCI_ERR_COLUMN_NOT_FOUND - Added Exception type OCI_ERR_DIRPATH_STATE - updated demo application with a direct path loading example - Added source code of a standalone application in demo directory * Modified Database objects describe API - OCI_Schema handle has been renamed to <a class="code" href="struct_o_c_i___type_info.html" title="Type info metadata handle.">OCI_TypeInfo</a> - All OCI_SchemaXXX() functions have been renamed to OCI_TypeInfoXXX() - Constants OCI_SCHEMA_XXX have been renamed to OCI_TIF_XXX - Macro have been added to mapp old types, defines and names to new ones for backward compatibility * Extended binding possibilities - Added <a class="code" href="group__g__bind.html#gc4d78a514b3d9fa1cdeb561e98d8140d" title="Return the current input array size for bulk operations.">OCI_BindArrayGetSize</a>() - Added <a class="code" href="group__g__bind.html#gf1aa3a489ea1c2f53273b986d46e2d68" title="Allow different host variables to be binded using the same bind name or position...">OCI_AllowRebinding</a>() - Different host variables can be binded to the same statement bind placeholder - It's possible the update a bind array real number of element before execution - Added exception type OCI_ERR_BIND_ARRAY_SIZE - Fixed OCI_SetNullXXX() : the upper bound of an array bind was not checked * Extended Object API - Added <a class="code" href="group__g__usertypes.html#g71b757d4e9babc24a4e3a2a5b4dfeb4e" title="Retrieve the underlying C (OTT/OCI style) structure of an OCI_Object handle.">OCI_ObjectGetStruct</a>() - Now it's possible to retrieve the underlying C (OTT style) structure of an <a class="code" href="struct_o_c_i___object.html" title="Oracle Named types representation.">OCI_Object</a> handle * Fixed OCI_Element API - Modified <a class="code" href="group__g__collection.html#g2103a0d8230001c7fc217189688244cb" title="Create a local collection element instance based on a collection type descriptor...">OCI_ElemCreate</a>() that takes now an <a class="code" href="struct_o_c_i___type_info.html" title="Type info metadata handle.">OCI_TypeInfo</a> handle instead of an <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a> handle - Fixed <a class="code" href="group__g__collection.html#gdf1010d812aa53c3b27d991fa47b4f98" title="Free a local collection element.">OCI_ElemFree</a>() that could not free underlying sub objects OCI handles - Fixed segfaults when using local instance of <a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> objects created wit <a class="code" href="group__g__collection.html#g2103a0d8230001c7fc217189688244cb" title="Create a local collection element instance based on a collection type descriptor...">OCI_ElemCreate</a>() * Extended UROWID support - Large UROWID hexadecimal strings where truncated to OCI_ROWID_SIZE (default 23) characters - Now OCILIB handles correctly UROWID columns (size up to 4000 chars) * Miscellaneous fixes - Fixed <a class="code" href="group__g__timestamp.html#g5b38e5b80794e324b17adf60dc851b03" title="Affect an OCI_Timestamp handle value to ISO C time datatypes.">OCI_TimestampToCTime</a>() : members tm_year and tm_mon of the tm structure passed to the function were not properly set - Fixed memory leak : when re-executing a prepared statement that hold a SQL 'select', internal OCI column descriptor for each column of the resultset was not freed - Fixed implicit conversion of numeric data to <span class="keywordtype">string</span> when using <a class="code" href="group__g__fetch.html#g755a9b07c174feacd05c86e0e44b0ab0" title="Return the current string value of the column at the given index in the resultset...">OCI_GetString</a>() in mixed and Unicode builds : Entire values had a trailing dot.⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -