index.html

oci的源码,可以在任何平台上编译,相当方便实用

      - Added <a class="code" href="group__g__bind.html#g995a87b09954d673d48e4b1437f892ea" title="Set the bind variable of the given name to null.">OCI_SetNull2</a>()
      - Added <a class="code" href="group__g__bind.html#gd7ee231660a5a4df6c9de357f033ef07" title="Set to null the bind variable of the given name in an input array.">OCI_SetNullAtPos2</a>()
      - Extended OCIBindxxx() calls satefy : 

        * An error OCI_ERR_BIND_ALREADY_USED is now raised if the bind name or position is already binded to the statement
        * With the bind mode by position, provided bind indexes &lt;= 0  and &gt; OCI_BIND_MAX will cause an error OCI_ERR_OUT_OF_BOUNDS

      - Extended binds/registers limits :
 
        * OCI implements the SQL returning clause through binds operations
        * OCILIB wraps the result of the returning clause within OCI_Resultet <span class="keywordtype">object</span> but has to use internal binds to create its resultset
        * Prior to v3.1.0, OCI_BIND_MAX (default 512) was the maximum of OCI_Bindxxx() including OCI_Registerxxx() that an <a class="code" href="struct_o_c_i___statement.html" title="Oracle SQL or PL/SQL statement.">OCI_Statement</a> could handle
        * With v3.1.0, OCILIB can handle OCI_BIND_MAX user binds handle and OCI_BIND_MAX items in the returning clause

    * Fixed Unicode support for Unixes platforms

        * Unicode support for platforms with 4 bytes <span class="keywordtype">wchar_t</span> was broken
        * Fixed configure script was setting bad charset macros
        * Fixed some internal buffer expansion functions

    * Miscellaneous public modifications

      - Added <a class="code" href="group__g__fetch.html#g5de0d8d520b5d748b2b2f6f38903cefd" title="Check if the current row value is null for the column of the given name in the resultset...">OCI_IsNull2</a>()
      - Added <a class="code" href="group__g__fetch.html#g090e11bacc3f267859902e98b71e26fd" title="Return the statement handle associated with a resultset handle.">OCI_ResultsetGetStatement</a>()
      - Added <a class="code" href="group__g__bind.html#gb6290cbc2471b259efef975f3a2dc7a8" title="Bind an array of Collection handles.">OCI_BindArrayOfColls</a>()
      - Added <a class="code" href="group__g__fetch.html#gdf36f1e4b9b955350dec1882d1c2102b" title="Return the current row data length of the column at the given index in the resultset...">OCI_GetDataLength</a>()
  
      - Added functions to retrieve OCI_Schema <span class="keywordtype">object</span> from various OCILIB <span class="keywordtype">object</span> bases on Oracle <span class="keywordtype">object</span> type :

        * Added OCI_ObjectGetSchema()
        * Added OCI_CollGetSchema()
        * Added OCI_RefGetSchema()

      - Added runtime information about OCILIB builds modes :

        * Added <a class="code" href="group__g__init.html#gecbebbd3747c5012dfbf072f90e33c77" title="Return the Oracle shared library import mode.">OCI_GetImportMode</a>()
        * Added <a class="code" href="group__g__init.html#gb6f4587e77cfa0f0696f1a676080b9d7" title="Return the metadata charset type.">OCI_GetCharsetMetaData</a>()
        * Added <a class="code" href="group__g__init.html#ge4f4cbad741ad0c35d9470708a3a0f15" title="Return the user data charset type.">OCI_GetCharsetUserData</a>()

      - On Oracle versions &gt;= 11g, OCILIB now sets the client driver layer name information

        * Value set to the constant OCILIB_DRIVER_NAME (by default "OCILIB") 
        * It's recorded in the system views V$SESSION_CONNECT_INFO and GV$SESSION_CONNECT_INFO

      - Modified ocilib demo to properly support MinGw and unix based unicode console output

    * Miscellaneous internal modifications

      - Added internal reference counter to OCI_Schema <span class="keywordtype">object</span> 

        * Some OCILIB objects keep a pointer to some OCI_schema objects
        * If OCI_SchemaFree() was called, these objects were holding a reference to a freed block of memory and then accessing this reference could cause a segfault
        * Now OCI_SchemaFree() only frees an schema <span class="keywordtype">object</span> if its reference counter is zero.
       
    * Miscellaneous fixes

      - <a class="code" href="group__g__fetch.html#g81e501b509b84d999e4337e2e11a90ec" title="Fetch the previous row of the resultset.">OCI_FetchPrev</a>() was returning FALSE if called directly after <a class="code" href="group__g__fetch.html#gb2b3f30ace2a89b07dd7803c82a523e7" title="Fetch the last row of the resultset.">OCI_FetchLast</a>() on resulsets with less then OCI_FETCH_SIZE rows (default set to 20)
      - if OCI_FetchXXX calls were returning FALSE, internal error flag was wrongly set to TRUE and <a class="code" href="group__g__error.html#gf2abe52ad5b278f65dd97a44a2adac4c" title="Retrieve the last error occurred within the last OCILIB call.">OCI_GetLastError</a>() could return a previous <a class="code" href="struct_o_c_i___error.html" title="Encapsulates an Oracle or OCILIB exception.">OCI_Error</a> handle
      - OCI_Fetchxxx() functions could return TRUE even if the given SQL statement had some SQL conversion function that failed (like to_date(), etc..)
      - OCI_Getxxx() functions could cause a segfault called before any OCI_Fetchxxx() calls 
      - <a class="code" href="group__g__connect.html#gaa13dc7489eeebcc6bd2a54fb88248b7" title="Returns TRUE is the given connection is still connected otherwise FALSE.">OCI_IsConnected</a>() was always returning FALSE since v3.0.0
      - OCI_SchemaGet() with OCI_SCHEMA_TABLE was causing an ORA-24328 with Oracle 8 and 9 (working fine with Oracle 10) since v3.0.0
      - <a class="code" href="group__g__exec.html#g7189aa353845909aaedc8d5956429450" title="Execute a prepared SQL statement or PL/SQL block.">OCI_Execute</a>() could raise an ORA-01483 if an <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> handle of type OCI_TIMESTAMP, initialized with <a class="code" href="group__g__timestamp.html#g1ca2a6227987c26ef8f561d47ffc24fb" title="Stores the system current date and time as a timestamp value with time zone into...">OCI_TimestampSysTimeStamp</a>() only, was binded to the statement
      - Fixed <a class="code" href="group__g__timestamp.html#g43028a0463f25bcd9665993a244572e7" title="Add an interval value to a timestamp value of a timestamp handle.">OCI_TimestampIntervalAdd</a>() and <a class="code" href="group__g__timestamp.html#ga3353b2e9b5ed9e7ffa2019e9232246c" title="Subtract an interval value from a timestamp value of a timestamp handle.">OCI_TimestampIntervalSub</a>() that might have raised errors with <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> handles of type OCI_TIMESTAMP
      - Fixed some preprocessor directives in oci_loader.h
      - Fixed <a class="code" href="struct_o_c_i___object.html" title="Oracle Named types representation.">OCI_Object</a> reusability: internal sub <span class="keywordtype">object</span> could not be freed when fetching next <span class="keywordtype">object</span> and thus lead to memory leaks
      - Since v3.0.0, fetching LONG column with OCI_LONG_IMPLICIT mode was truncating data to its half length in Unicode and Mixed Builds 
      - Fixed some preprocessor directives for MinGw support
      - Fixed runtime loading of oracle libs that might have not worked if the provided OCI library location ended with an existing slash
      - Fixed internal OCI_CopyString() that might caused some troubles in Unicode builds 
      - Fixed some internal wrong arrays size used for memory allocation
      - Fixed some <a class="code" href="struct_o_c_i___date.html" title="Oracle internal date representation.">OCI_Date</a> and <a class="code" href="struct_o_c_i___timestamp.html" title="Oracle internal timestamp representation.">OCI_Timestamp</a> decode functions to work properly on big-endian platforms
      - Fixed <span class="keywordtype">string</span> binding on mixed charset build iwth Oracle 8i
      - since v3.0.0, OCILIB source compilation was broken for oracle 8i
      - Fixed demo file output.c

2008-10-17 Version 3.0.1 Vincent Rogier [e-mail]

    * Miscellaneous fixes

      - Added checks (OCI_ERR_MIN_VALUE) on len parameter (len &gt;=1) of <a class="code" href="group__g__lob.html#g36708313dc7d5c0b2c30f7f8b9fa2e2d" title="Read a portion of a lob into the given buffer.">OCI_LobRead</a>(), OCI_LobApend(), <a class="code" href="group__g__lob.html#g949f7050609430486c9ef0f3c488d38a" title="Write a buffer into a LOB.">OCI_LobWrite</a>(), <a class="code" href="group__g__file.html#gf6400291c6338fc6be4dfdc3a6f5eb55" title="Read a portion of a file into the given buffer.">OCI_FileRead</a>()
      - Compilation of ocilib source with MSCV6++ was broken (vsnprintf was not defined to _vsnprintf anymore)
      - Memory leak : internal bind data allocated for handling PL/SQL tables was never freed 
      - Memory leak : internal <a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a> <span class="keywordtype">object</span> used by <a class="code" href="struct_o_c_i___coll.html" title="Oracle Collections (VARRAYs and Nested Tables) representation.">OCI_Coll</a> was never freed
      - Memory leak : since v3.0.0,  <a class="code" href="struct_o_c_i___statement.html" title="Oracle SQL or PL/SQL statement.">OCI_Statement</a> internal stored SQL command <span class="keywordtype">string</span> was not freed anymore
      - Scrollable cursors : executing a non select query on a scrollable statement was causing an oracle error

    * The library has been re-tested with various test suites under valgrind to check memory handling and it is now clean !

2008-10-13 Version 3.0.0 Vincent Rogier [e-mail]

    * Added support for scrollable cursors

      - See section in the documentation (page &lt;module&gt;, section &lt;Fetching data&gt;)
      - Added <a class="code" href="group__g__fetch.html#g81e501b509b84d999e4337e2e11a90ec" title="Fetch the previous row of the resultset.">OCI_FetchPrev</a>()
      - Added <a class="code" href="group__g__fetch.html#gb2b3f30ace2a89b07dd7803c82a523e7" title="Fetch the last row of the resultset.">OCI_FetchLast</a>()
      - Added <a class="code" href="group__g__fetch.html#gf26bde3f9db77231d66107af24a51d96" title="Fetch the first row of the resultset.">OCI_FetchFirst</a>()
      - Added <a class="code" href="group__g__fetch.html#g99372dc21a4965ca74d8fdde2069cc10" title="Custom Fetch of the resultset.">OCI_FetchSeek</a>()
      - Added <a class="code" href="group__g__stmt.html#g83e1c31e40926a84651eb60fefd50d5e" title="Set the fetch mode of a SQL statement.">OCI_SetFetchMode</a>()
      - Added <a class="code" href="group__g__stmt.html#gf6035956d1fd5962753443ead90e2660" title="Return the fetch mode of a SQL statement.">OCI_GetFetchMode</a>()
      - Added <a class="code" href="group__g__fetch.html#g4add0a9c53a23b334197c655b46b620c" title="Retrieve the current row number.">OCI_GetCurrentRow</a>()

    * Added support for Collection types : VARRAYs and NESTED TABLES

      - Added section in the documentation (page &lt;module&gt; - section &lt;Oracle Collections (Varrays and Nested Tables)&gt;)
      - Added type <a class="code" href="struct_o_c_i___coll.html" title="Oracle Collections (VARRAYs and Nested Tables) representation.">OCI_Coll</a>
      - Added type <a class="code" href="struct_o_c_i___iter.html" title="Oracle Collection iterator representation.">OCI_Iter</a>
      - Added type <a class="code" href="struct_o_c_i___elem.html" title="Oracle Collection item representation.">OCI_Elem</a>
      - Added <a class="code" href="group__g__collection.html#ga2c5c18fa416fe1f955ccb5dbff43046" title="Create a local collection instance.">OCI_CollCreate</a>()
      - Added <a class="code" href="group__g__collection.html#g8663babe980c99ff0441feedff973912" title="Free a local collection.">OCI_CollFree</a>()
      - Added <a class="code" href="group__g__collection.html#g5121ce70006885b5f45df2c764ec8d8e" title="Assign a collection to another one.">OCI_CollAssign</a>()
      - Added <a class="code" href="group__g__collection.html#g18518027318ac527c9cbefab4f16b7ba" title="Return the collection type.">OCI_CollGetType</a>()
      - Added <a class="code" href="group__g__collection.html#gfdc86421c73ed6955a965097cb335a64" title="Returns the maximum number of elements of the given collection.">OCI_CollGetMax</a>()