📄 group__lob.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"><title>libsqlora8: Functions to insert/select LOBs</title><link href="doxygen.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.3.6 --><div class="qindex"><a class="qindex" href="index.html">Main Page</a> | <a class="qindex" href="modules.html">Modules</a> | <a class="qindex" href="annotated.html">Data Structures</a> | <a class="qindex" href="files.html">File List</a> | <a class="qindex" href="functions.html">Data Fields</a> | <a class="qindex" href="globals.html">Globals</a> | <a class="qindex" href="pages.html">Related Pages</a> | <a class="qindex" href="examples.html">Examples</a></div><h1>Functions to insert/select LOBs</h1><table border=0 cellpadding=0 cellspacing=0><tr><td></td></tr><tr><td colspan=2><br><h2>Functions</h2></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga0">sqlo_alloc_lob_desc</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> *loblpp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Allocate a lob descriptor. <a href="#ga0"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga1">sqlo_free_lob_desc</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> *loblpp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Free a lob descriptor. <a href="#ga1"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga2">sqlo_lob_write_buffer</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> loblp, unsigned int loblen, void *bufp, unsigned int bufl, unsigned int piece)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Write lob data from buffer into the lob column. <a href="#ga2"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga3">sqlo_lob_append_buffer</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> loblp, unsigned int loblen, void *bufp, unsigned int bufl, unsigned int piece)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Append lob data from buffer to the lob column. <a href="#ga3"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga4">sqlo_lob_write_stream</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> loblp, unsigned int filelen, FILE *fp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Write lob data from a file into the lob column. <a href="#ga4"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga5">sqlo_lob_get_length</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> loblp, unsigned int *loblenp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the length of a lob. <a href="#ga5"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga6">sqlo_lob_read_buffer</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> loblp, unsigned int loblen, void *bufp, unsigned int bufl)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Read lob data from lob column into a buffer. <a href="#ga6"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__lob.html#ga7">sqlo_lob_read_stream</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> loblp, unsigned int loblen, FILE *fp)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Read lob data from lob column into a stream. <a href="#ga7"></a><br><br></td></tr></table><hr><h2>Function Documentation</h2><a class="anchor" name="ga0" doxytag="sqlora.h::sqlo_alloc_lob_desc" ></a><p><table class="mdTable" width="100%" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top"> int sqlo_alloc_lob_desc </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> </td> <td class="mdname" nowrap> <em>dbh</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap><a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> * </td> <td class="mdname" nowrap> <em>loblpp</em></td> </tr> <tr> <td></td> <td class="md">) </td> <td class="md" colspan="2"></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Allocate a lob descriptor. <p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign=top><em>dbh</em> </td><td>I - A database handle </td></tr> <tr><td valign=top><em>loblpp</em> </td><td>O - The lob locator</td></tr> </table></dl><dl compact><dt><b>Returns:</b></dt><dd>SQLO_SUCCESS or < 0 on error </dd></dl><dl compact><dt><b>Since:</b></dt><dd>Version 2.2 </dd></dl><p>Definition at line <a class="el" href="sqlora_8c-source.html#l07356">7356</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.<p>References <a class="el" href="sqlora_8c-source.html#l00340">CHECK_DBHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00489">_sqlo_db_struct::envhp</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga4a34">SQLO_INVALID_DB_HANDLE</a>, <a class="el" href="sqlora_8h-source.html#l00341">sqlo_lob_desc_t</a>, and <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>. </td> </tr></table><a class="anchor" name="ga1" doxytag="sqlora.h::sqlo_free_lob_desc" ></a><p><table class="mdTable" width="100%" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top"> int sqlo_free_lob_desc </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> </td> <td class="mdname" nowrap> <em>dbh</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap><a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> * </td> <td class="mdname" nowrap> <em>loblpp</em></td> </tr> <tr> <td></td> <td class="md">) </td> <td class="md" colspan="2"></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Free a lob descriptor. <p>Frees the descriptor and sets *loblp to NULL.<p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign=top><em>dbh</em> </td><td>I - A database handle </td></tr> <tr><td valign=top><em>loblpp</em> </td><td>I/O - A address where we find the lob locator.</td></tr> </table></dl><dl compact><dt><b>Returns:</b></dt><dd><ul><li>SQLO_SUCCESS </li><li>< 0 on error </li></ul></dd></dl><dl compact><dt><b>Since:</b></dt><dd>Version 2.2 </dd></dl><p>Definition at line <a class="el" href="sqlora_8c-source.html#l07381">7381</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.<p>References <a class="el" href="sqlora_8c-source.html#l00340">CHECK_DBHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00495">_sqlo_db_struct::errmsg</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga3a26">SQLO_ERROR</a>, <a class="el" href="group__constants.html#gga4a34">SQLO_INVALID_DB_HANDLE</a>, <a class="el" href="sqlora_8h-source.html#l00341">sqlo_lob_desc_t</a>, and <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>. </td> </tr></table><a class="anchor" name="ga3" doxytag="sqlora.h::sqlo_lob_append_buffer" ></a><p><table class="mdTable" width="100%" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top"> int sqlo_lob_append_buffer </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> </td> <td class="mdname" nowrap> <em>dbh</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap><a class="el" href="group__typedefs.html#ga2">sqlo_lob_desc_t</a> </td> <td class="mdname" nowrap> <em>loblp</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>unsigned int </td> <td class="mdname" nowrap> <em>loblen</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>void * </td> <td class="mdname" nowrap> <em>bufp</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>unsigned int </td> <td class="mdname" nowrap> <em>bufl</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>unsigned int </td> <td class="mdname" nowrap> <em>piece</em></td> </tr> <tr> <td></td> <td class="md">) </td> <td class="md" colspan="2"></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Append lob data from buffer to the lob column. <p><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign=top><em>dbh</em> </td><td>I - A database handle. </td></tr> <tr><td valign=top><em>loblen</em> </td><td>I - The length of the lob. </td></tr> <tr><td valign=top><em>loblp</em> </td><td>I - A lob locator. </td></tr> <tr><td valign=top><em>bufp</em> </td><td>I - A buffer of data. </td></tr> <tr><td valign=top><em>bufl</em> </td><td>I - The length of the buffer in terms of bytes. </td></tr> <tr><td valign=top><em>piece</em> </td><td>I - The piece indicator <ul><li>SQLO_ONE_PIECE </li><li>SQLO_FIRST_PIECE </li><li>SQLO_NEXT_PIECE </li><li>SQLO_LAST_PIECE </li></ul></td></tr> </table></dl><dl compact><dt><b>Returns:</b></dt><dd><ul><li>SQLO_SUCCESS </li><li>SQLO_STILL_EXECUTING </li><li>SQLO_ERROR (always when OCILobWriteAppend is not available in your Oracle version) </li></ul></dd></dl><dl compact><dt><b>Since:</b></dt><dd>Version 2.2 and Oracle version >= 8.1 </dd></dl><dl compact><dt><b>Example:</b></dt><dd><div class="fragment"><pre><span class="comment">/* $Id: ex13.c,v 1.6 2004/01/03 16:48:19 kpoitschke Exp $ */</span><span class="preprocessor">#include <stdio.h></span><span class="preprocessor">#include <stdlib.h></span><span class="preprocessor">#include "examples.h"</span><span class="keywordtype">int</span> insert_into_blob_table(<a class="code" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, <span class="keywordtype">int</span> key )⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -