group__g__dirpath.html

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

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">return the number of rows successfully processed during in the last conversion or loading call  <a href="#gade590aadb20d903770d9dc9c82ddb0c"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__dirpath.html#g957a4d36b54166195cebeca461ddc7c4">OCI_DirPathGetErrorColumn</a> (<a class="el" href="struct_o_c_i___dir_path.html">OCI_DirPath</a> *dp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Return the column index which caused an error during data conversion.  <a href="#g957a4d36b54166195cebeca461ddc7c4"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">OCI_EXPORT unsigned int OCI_API&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="group__g__dirpath.html#g29e788b14e1e9ecd691c101c38f9e118">OCI_DirPathGetErrorRow</a> (<a class="el" href="struct_o_c_i___dir_path.html">OCI_DirPath</a> *dp)</td></tr>

<tr><td class="mdescLeft">&nbsp;</td><td class="mdescRight">Return the row index which caused an error during data conversion.  <a href="#g29e788b14e1e9ecd691c101c38f9e118"></a><br></td></tr>
</table>
<hr><h2>Function Documentation</h2>
<a class="anchor" name="g382a1cbd623aa97ca69fed7b26923d61"></a><!-- doxytag: member="ocilib.h::OCI_DirPathAbort" ref="g382a1cbd623aa97ca69fed7b26923d61" args="(OCI_DirPath *dp)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_DirPathAbort           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___dir_path.html">OCI_DirPath</a> *&nbsp;</td>
          <td class="paramname"> <em>dp</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Terminate a direct path operation without committing changes. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>dp</em>&nbsp;</td><td>- Direct path Handle</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Any pending loaded data are cancelled. Any load completion operations, such as index maintenance operations, are not performed.</dd></dl>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd>The direct path handle cannot be used anymore after this call for any more loading operations and must be freed with <a class="el" href="group__g__dirpath.html#g024f04e69293349e3882b2f367a03ed6" title="Free an OCI_DirPath handle.">OCI_DirPathFree()</a>.</dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Definition at line <a class="el" href="dirpath_8c-source.html#l01002">1002</a> of file <a class="el" href="dirpath_8c-source.html">dirpath.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00665">OCI_DirPath::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00667">OCI_DirPath::ctx</a>, <a class="el" href="ocilib__types_8h-source.html#l00267">OCI_Connection::err</a>, and <a class="el" href="ocilib__types_8h-source.html#l00678">OCI_DirPath::status</a>.</p>

</div>
</div><p>
<a class="anchor" name="g8dd680e9664028af035e773275e5ab76"></a><!-- doxytag: member="ocilib.h::OCI_DirPathConvert" ref="g8dd680e9664028af035e773275e5ab76" args="(OCI_DirPath *dp)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT unsigned int OCI_API OCI_DirPathConvert           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___dir_path.html">OCI_DirPath</a> *&nbsp;</td>
          <td class="paramname"> <em>dp</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Convert user provided data to a direct path stream format. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>dp</em>&nbsp;</td><td>- Direct path Handle</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>if the call does return another result than OCI_DPR_COMPLETE :<ul>
<li><a class="el" href="group__g__dirpath.html#g29e788b14e1e9ecd691c101c38f9e118" title="Return the row index which caused an error during data conversion.">OCI_DirPathGetErrorRow()</a> returns the row where the error occured</li><li><a class="el" href="group__g__dirpath.html#g957a4d36b54166195cebeca461ddc7c4" title="Return the column index which caused an error during data conversion.">OCI_DirPathGetErrorColumn()</a> returns the column where the error occured</li></ul>
<p>
<a class="el" href="group__g__dirpath.html#gade590aadb20d903770d9dc9c82ddb0c" title="return the number of rows successfully processed during in the last conversion or...">OCI_DirPathGetAffectedRows()</a> returns the number of rows processed in the last call.</dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>Possible return values :<ul>
<li>OCI_DPR_COMPLETE : load has been successful</li><li>OCI_DPR_ERROR : an error happened while loading data</li><li>OCI_DPR_FULL : the internal stream is full</li><li>OCI_DPR_PARTIAL : a column hasn't been fully filled yet</li><li>OCI_DPR_EMPTY : no data was found to load </li></ul>
</dd></dl>

<p>Definition at line <a class="el" href="dirpath_8c-source.html#l00780">780</a> of file <a class="el" href="dirpath_8c-source.html">dirpath.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00668">OCI_DirPath::arr</a>, <a class="el" href="ocilib__types_8h-source.html#l00670">OCI_DirPath::cols</a>, <a class="el" href="ocilib__types_8h-source.html#l00665">OCI_DirPath::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00667">OCI_DirPath::ctx</a>, <a class="el" href="ocilib__types_8h-source.html#l00267">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00676">OCI_DirPath::err_col</a>, <a class="el" href="ocilib__types_8h-source.html#l00677">OCI_DirPath::err_row</a>, <a class="el" href="ocilib__types_8h-source.html#l00671">OCI_DirPath::nb_cols</a>, <a class="el" href="ocilib__types_8h-source.html#l00673">OCI_DirPath::nb_cur</a>, <a class="el" href="ocilib__types_8h-source.html#l00675">OCI_DirPath::nb_prcsd</a>, <a class="el" href="ocilib__types_8h-source.html#l00678">OCI_DirPath::status</a>, and <a class="el" href="ocilib__types_8h-source.html#l00669">OCI_DirPath::strm</a>.</p>

</div>
</div><p>
<a class="anchor" name="g64dd9756aa24ead3addabf50db0d6f16"></a><!-- doxytag: member="ocilib.h::OCI_DirPathCreate" ref="g64dd9756aa24ead3addabf50db0d6f16" args="(OCI_TypeInfo *typinf, mtext *partition, unsigned int nb_cols, unsigned int nb_rows)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT <a class="el" href="struct_o_c_i___dir_path.html">OCI_DirPath</a>* OCI_API OCI_DirPathCreate           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___type_info.html">OCI_TypeInfo</a> *&nbsp;</td>
          <td class="paramname"> <em>typinf</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">mtext *&nbsp;</td>
          <td class="paramname"> <em>partition</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>nb_cols</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">unsigned int&nbsp;</td>
          <td class="paramname"> <em>nb_rows</em></td><td>&nbsp;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td><td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Create a direct path object. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>typinf</em>&nbsp;</td><td>- Table type info handle </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>partition</em>&nbsp;</td><td>- Partition name </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>nb_cols</em>&nbsp;</td><td>- Number of columns to load </td></tr>
    <tr><td valign="top"></td><td valign="top"><em>nb_rows</em>&nbsp;</td><td>- Maximum of rows to handle per load operation</td></tr>
  </table>
</dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Retrieve the table type info handle with <a class="el" href="group__g__desc.html#g4990c22d2773746a0ab61ec95470445c" title="Retrieve the available type info information.">OCI_TypeInfoGet()</a>. The partition name is not mandatory<p>
Parameter 'nb_rows' is ignored for Oracle 8i. Prior to Oracle 9i, it's the OCI client that decides of the number of rows to process per convert/load calls. From Oracle 9i, OCI allows application to specify this value. Note that, the OCI client might not accept the input value. After <a class="el" 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> has been successfully called, <a class="el" href="group__g__dirpath.html#g2ff812128f1604615f186aa8bdf8269d" title="Return the maximum number of rows allocated in the OCI and OCILIB internal arrays...">OCI_DirPathGetMaxRows()</a> returns the final number of rows used for the given direct path operation.</dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>Return the direct path handle on success otherwise NULL on failure </dd></dl>

<p>Definition at line <a class="el" href="dirpath_8c-source.html#l00045">45</a> of file <a class="el" href="dirpath_8c-source.html">dirpath.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00670">OCI_DirPath::cols</a>, <a class="el" href="ocilib__types_8h-source.html#l00665">OCI_DirPath::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00625">OCI_TypeInfo::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00667">OCI_DirPath::ctx</a>, <a class="el" href="ocilib__types_8h-source.html#l00267">OCI_Connection::err</a>, <a class="el" href="ocilib__types_8h-source.html#l00676">OCI_DirPath::err_col</a>, <a class="el" href="ocilib__types_8h-source.html#l00677">OCI_DirPath::err_row</a>, <a class="el" href="ocilib__types_8h-source.html#l00626">OCI_TypeInfo::name</a>, <a class="el" href="ocilib__types_8h-source.html#l00671">OCI_DirPath::nb_cols</a>, <a class="el" href="ocilib__types_8h-source.html#l00633">OCI_TypeInfo::nb_cols</a>, <a class="el" href="ocilib__types_8h-source.html#l00673">OCI_DirPath::nb_cur</a>, <a class="el" href="ocilib__types_8h-source.html#l00675">OCI_DirPath::nb_prcsd</a>, <a class="el" href="ocilib__types_8h-source.html#l00672">OCI_DirPath::nb_rows</a>, <a class="el" href="group__g__dirpath.html#g024f04e69293349e3882b2f367a03ed6">OCI_DirPathFree()</a>, <a class="el" href="ocilib__types_8h-source.html#l00627">OCI_TypeInfo::schema</a>, <a class="el" href="ocilib__types_8h-source.html#l00678">OCI_DirPath::status</a>, <a class="el" href="ocilib__types_8h-source.html#l00628">OCI_TypeInfo::type</a>, and <a class="el" href="ocilib__types_8h-source.html#l00666">OCI_DirPath::typinf</a>.</p>

</div>
</div><p>
<a class="anchor" name="g7c80a8db7ef79e4693ac0e770bb2018f"></a><!-- doxytag: member="ocilib.h::OCI_DirPathFinish" ref="g7c80a8db7ef79e4693ac0e770bb2018f" args="(OCI_DirPath *dp)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_DirPathFinish           </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="struct_o_c_i___dir_path.html">OCI_DirPath</a> *&nbsp;</td>
          <td class="paramname"> <em>dp</em>          </td>
          <td>&nbsp;)&nbsp;</td>
          <td width="100%"></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>
Terminate a direct path operation and commit changes into the database. 
<p>
<dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign="top"></td><td valign="top"><em>dp</em>&nbsp;</td><td>- Direct path Handle</td></tr>
  </table>
</dl>
<dl class="warning" compact><dt><b>Warning:</b></dt><dd>The direct path handle cannot be used anymore after this call for any more loading operations and must be freed with <a class="el" href="group__g__dirpath.html#g024f04e69293349e3882b2f367a03ed6" title="Free an OCI_DirPath handle.">OCI_DirPathFree()</a>.</dd></dl>
<dl class="note" compact><dt><b>Note:</b></dt><dd>Some properties functions of the direct path handle, such as <a class="el" href="group__g__dirpath.html#gffb07d43825826b0c9af060ee52fc3e0" title="Return the number of rows successfully loaded into the database so far.">OCI_DirPathGetRowCount()</a> can be called on a terminated direct path handle</dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>TRUE on success otherwise FALSE </dd></dl>

<p>Definition at line <a class="el" href="dirpath_8c-source.html#l00973">973</a> of file <a class="el" href="dirpath_8c-source.html">dirpath.c</a>.</p>

<p>References <a class="el" href="ocilib__types_8h-source.html#l00665">OCI_DirPath::con</a>, <a class="el" href="ocilib__types_8h-source.html#l00667">OCI_DirPath::ctx</a>, <a class="el" href="ocilib__types_8h-source.html#l00267">OCI_Connection::err</a>, <a class="el" href="group__g__dirpath.html#g2efc984ff0647d3a3c4b29f7e9ec37e2">OCI_DirPathReset()</a>, and <a class="el" href="ocilib__types_8h-source.html#l00678">OCI_DirPath::status</a>.</p>

</div>
</div><p>
<a class="anchor" name="gfe3add5d1595fbabab7e197ce26f9a67"></a><!-- doxytag: member="ocilib.h::OCI_DirPathFlushRow" ref="gfe3add5d1595fbabab7e197ce26f9a67" args="(OCI_DirPath *dp)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">OCI_EXPORT boolean OCI_API OCI_DirPathFlushRow           </td>
          <td>(</td>