index.html

ORACLE编程的好东西,纯C写的OCI封装.很好用,支持数据池.

 
      - Fixed : PL/SQL table pure IN binds was causing PL/SQL error when the table parameters was accessed by PL/SQL procedures
      - Fixed : Passing the value 1 for array size in PL/SQL tables binds caused an ORA-06550
  
    * Fixed Oracle Long fetching

      - Segmentation fault was happening if a select contained a LONG column + other columns
      - Unnecessary reallocation of internal LONG buffers was done at every internal fetch call (by default every 20 rows)
      - When using OCI_LONG_IMPLICIT (LONG mapped to VARCHAR), strings returned by <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>() might not have their final null character
       
    * Modified GNU configure scripts

      - Added    : For GNU builds added configure option --with-custom-loader for platforms that are not using '-ldl' (if using option --with-oracle-linkage=runtime)
      - Fixed    : Some configure options were broken
      - Modified : Added some checks and some outputs

    * Miscellaneous fixes

      - Fixed : Replaced any references of '<span class="keywordtype">long</span>' C type with '<span class="keywordtype">int</span>' C types in unix wchar internal conversion functions (on 64bits platforms, 
                sizeof(<span class="keywordtype">long</span>) is 8 bytes so it lead to some buffer bad alignment)
      - Fixed : Second parameter 'ptm' of <a class="code" href="group__g__date.html#g52fb4405771971a2603e3eb871b3256e" title="Affect an OCI_Date handle value to ISO C time datatypes.">OCI_DateToCTime</a>() and <a class="code" href="group__g__timestamp.html#g5b38e5b80794e324b17adf60dc851b03" title="Affect an OCI_Timestamp handle value to ISO C time datatypes.">OCI_TimestampToCTime</a>() was not mandatory as it should have been
      - Fixed : Unicode buffer conversion : Internal OCI_StringLength() could not work properly on some architectures
      - Fixed : Binding 64bits integers was not working properly (wrong internal flags)
      - Fixed : <a class="code" href="group__g__usertypes.html#gbeb0db1bb555a25b3012838aae3b9d11" title="Return the short value of the given object attribute.">OCI_ObjectGetShort</a>() and <a class="code" href="group__g__usertypes.html#gd3b4fbb26ad147d477a9865fffa318f7" title="Return the unsigned short value of the given object attribute.">OCI_ObjectGetUnsignedShort</a>() were missing in ocilib.c
      - Fixed : the header "limits.h" was not included in ocilib.h and on some configurations the support of '<span class="keywordtype">long</span> <span class="keywordtype">long</span>' could not be detected
      - Fixed : CLOBs read/writes on OCILIB Unix/Unicode builds could not work properly (wrong buffer passed to OCI)
      - Fixed : <a class="code" href="group__g__connect.html#geed5fe2da7af18c69585fbec9f63c951" title="Associate to the given connection a pointer to user data.">OCI_SetUserData</a>() was not exported
      - Fixed : return value of the declaration of <a class="code" href="group__g__connect.html#g6f61147801fce4b69edb4981ba4ea1b7" title="Return the highest Oracle version is supported by the connection.">OCI_GetVersionConnection</a>() was wrong (<span class="keywordtype">boolean</span> instead of <span class="keywordtype">unsigned</span> <span class="keywordtype">int</span>)
      - Fixed : <a class="code" href="group__g__plsql.html#geff8f38ba15b9e757cec70d91e4ffe13" title="Enable the server output.">OCI_ServerEnableOutput</a>() and <a class="code" href="group__g__plsql.html#g0d3321a0abff0722baf6b2b7233f4cb5" title="Disable the server output.">OCI_ServerDisableOutput</a>() prototypes didn't have the OCI_API call convention (for MS builds)
      - Fixed : <a class="code" href="group__g__usertypes.html#g95ba08a32cf97b7bed6235cc48bd2300" title="Return the string value of the given object attribute.">OCI_ObjectGetString</a>() prototype was returning wrong type 'mtext *' instead of 'dtext *'

    * Updated main demo application

      - Added : Example for scrollable cursors and collections (varrays and nested tables)
      - Fixed : some bad cast could lead buffer bad filling in mixed charset build

    * Fixed Mixed charset builds (OCI_CHARSET_MIXED ONLY)

      - Fixed : <a class="code" href="group__g__usertypes.html#g95ba08a32cf97b7bed6235cc48bd2300" title="Return the string value of the given object attribute.">OCI_ObjectGetString</a>() and <a class="code" href="group__g__usertypes.html#g93eb03a281c7a798bc804eb4a3496799" title="Set an object attribute of type string.">OCI_ObjectSetString</a>() were misunderstanding <span class="keywordtype">string</span> buffers
      - Fixed : <a class="code" href="group__g__plsql.html#geff8f38ba15b9e757cec70d91e4ffe13" title="Enable the server output.">OCI_ServerEnableOutput</a>() was not allocating enough memory to hold output buffer lines
      - Info  : OCILIB functions using the OCI functions OCIStringPtr() and OCIStringAssignText() have a limitation on mixed charset builds :

        * In mixed builds, OCILIB Strings (dtext *) used for handling user data are <span class="keywordtype">wchar_t</span> strings, but the underlying OCI API 
          understands theses strings as not unicode but ansi or other encoding 
        * So, there is now, when building OCILIB with OCI_CHARSET_MIXED, an internal conversion to/from ANSI data when using :
          
          - <a class="code" href="group__g__usertypes.html#g95ba08a32cf97b7bed6235cc48bd2300" title="Return the string value of the given object attribute.">OCI_ObjectGetString</a>() and <a class="code" href="group__g__usertypes.html#g93eb03a281c7a798bc804eb4a3496799" title="Set an object attribute of type string.">OCI_ObjectSetString</a>()
          - <a class="code" href="group__g__collection.html#g3f37f83b33c65908812643ef68f31db1" title="Return the String value of the given collection element.">OCI_ElemGetString</a>() and <a class="code" href="group__g__collection.html#g79fa00247b1d950c261c568358033b53" title="Set a string value to an collection element.">OCI_ElemSetString</a>()

2008-07-24 Version 2.5.1 Vincent Rogier [e-mail]

    * Fixed : OCILIB builds with Runtime loading of OCI shared library activated

      - Loading dynamically OCIMutexXXX() functions was broken with v2.5.0
      - Runtime loading of the OCI shared library on Unix-like platforms was broken with v2.5.0

    * Fixed Unicode builds: 

      - Binding C Unicode strings (<span class="keywordtype">wchar_t</span> *) to PL/SQL tables of <span class="keywordtype">char</span>/varchar was throwing an PLS-00418 error 
      - The internal buffer expansion (for Unix-like platforms where <span class="keywordtype">wchar_t</span> is 4 bytes) could mess up the data for arrays of <span class="keywordtype">string</span> binds
      - <a class="code" href="group__g__connpool.html#g774ce156deb3477c83237a633b6538f6" title="Get a connection from the pool.">OCI_ConnPoolGetConnection</a>() could return NULL with an Oracle 8i client if OCILIB was built with an OCI version &gt;= 8 or with OCI_IMPORT_RUNTIME option

2008-07-21 Version 2.5.0 Vincent Rogier [e-mail]

    * Added support for PL/SQL tables (PL/SQL arrays)

      - Bind (input, output) C arrays to PL/SQL using OCI_BindArrayOfxxx() functions
      - All the OCI_BindArrayOfxxx() functions take now an extra param : the size of the array for PL/PL/SQL table
      - For regular array interface bind, pass 0 for the array size which is set by <a class="code" href="group__g__bind.html#g60d87fbeb94afeaf410ec243eb8c0f98" title="Set the input array size for bulk operations.">OCI_BindArraySetSize</a>() 

    * Extended Date, timestamp and interval support

      - Added <a class="code" href="group__g__date.html#g0c33ca23c117aab2c8197ae7fdb657c8" title="Extract the date and time parts from a date handle.">OCI_DateGetDateTime</a>()
      - Added <a class="code" href="group__g__date.html#gb5e4890df370609f9a8267125c52123e" title="Set the date and time portions if the given date handle.">OCI_DateSetDateTime</a>()
      - Added support for converting C types (time_t, tm) to/from <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 timespamp representation.">OCI_Timestamp</a> :

        * Added <a class="code" href="group__g__date.html#g5022740b8e062a289d7d06a2f5bd40ca" title="Affect ISO C time datatypes values to an OCI_Date handle.">OCI_DateFromCTime</a>()
        * Added <a class="code" href="group__g__date.html#g52fb4405771971a2603e3eb871b3256e" title="Affect an OCI_Date handle value to ISO C time datatypes.">OCI_DateToCTime</a>()
        * Added <a class="code" href="group__g__timestamp.html#g69f6172371a6a70fcecb2c4e1d34a360" title="Affect ISO C time datatypes values to an OCI_Timestamp handle.">OCI_TimestampFromCTime</a>()
        * Added <a class="code" href="group__g__timestamp.html#g5b38e5b80794e324b17adf60dc851b03" title="Affect an OCI_Timestamp handle value to ISO C time datatypes.">OCI_TimestampToCTime</a>()

      - Date, timestamp and interval can now be create outside a database connection:
            
        * To create a connection independent <span class="keywordtype">object</span>, pass a NULL <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a> pointer to <a class="code" href="group__g__date.html#ge80eacef54641a68c3b82be85f4a5042" title="Create a local date object.">OCI_DateCreate</a>(), <a class="code" href="group__g__timestamp.html#g5c590ea371920703997cd7bea126ad9d" title="Create a local Timestamp instance.">OCI_TimestampCreate</a>() and OCI_intervalCreate() functions
        * Keep in mind that using a connection pointer is still recommended because it's checking that the server is able to handle these datatypes

      - 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>(), <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>() : 

        * If the timestamps type was not OCI_TIMESTAMP_TZ, an error occured
        * Now, these functions changes the timestamps types for OCI raw call and set it back before returning
        * Possible bug OCI -&gt; Investigating with Oracle support 

    * Extended <a class="code" href="struct_o_c_i___connection.html" title="Oracle physical connection.">OCI_Connection</a> handle attributes

      - Added <a class="code" href="group__g__connect.html#gaa13dc7489eeebcc6bd2a54fb88248b7" title="Returns TRUE is the given connection is still connected otherwise FALSE.">OCI_IsConnected</a>()
      - Added <a class="code" href="group__g__connect.html#geed5fe2da7af18c69585fbec9f63c951" title="Associate to the given connection a pointer to user data.">OCI_SetUserData</a>()
      - Added <a class="code" href="group__g__connect.html#g79621217bc8fb84907c453258a2a33e1" title="Return the previously pointer to user data associated with the connection.">OCI_GetUserData</a>()

    * Added Support for retrieving server output

      - Added <a class="code" href="group__g__plsql.html#geff8f38ba15b9e757cec70d91e4ffe13" title="Enable the server output.">OCI_ServerEnableOutput</a>()
      - Added <a class="code" href="group__g__plsql.html#g0d3321a0abff0722baf6b2b7233f4cb5" title="Disable the server output.">OCI_ServerDisableOutput</a>()
      - Added <a class="code" href="group__g__plsql.html#gbb13df960f035cd9e48e774c39db425a" title="Retreive one line the of server buffer.">OCI_ServerGetOutput</a>()

    * Added Support for OCI Threadkeys
     
      - Thread Keys are kind of process wide variable identified by an <span class="keywordtype">string</span> identifier with thread specific values
      - See section in the documentation (page &lt;module&gt;, section &lt;Threads and mutexes&gt;)
      - Added <a class="code" href="group__g__threads.html#g77348c8397b1fdf0a4046a252fb6bd4c" title="Create a thread key object.">OCI_ThreadKeyCreate</a>()
      - Added <a class="code" href="group__g__threads.html#g6d02f4af58c0615e649d47d775e5fc3e" title="Get a thread key value.">OCI_ThreadKeyGetValue</a>()
      - Added <a class="code" href="group__g__threads.html#g0b4232385d2b82a5a35d8ff2afa046c6" title="Set a thread key value.">OCI_ThreadKeySetValue</a>()

    * Extended runtime loading of Oracle shared libs on various Unix-like systems

      - Added support for Mac OSX (handling 'dylib' lib extension)
      - Added support for some HP/UX platforms (handling 'sl' lib extension)
      - Modified dl_open() flags for AIX and HP/UX
      - Modified configure script for Oracle shared Client library detection

    * Added Support for Oracle Instant Client on Unix-like systems