Sophie

Sophie

distrib > Fedora > 14 > x86_64 > media > updates > by-pkgid > 71d40963b505df4524269198e237b3e3 > files > 387

virtuoso-opensource-doc-6.1.4-2.fc14.noarch.rpm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
 <head profile="http://internetalchemy.org/2003/02/profile">
  <link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
  <link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
  <meta name="dc.title" content="Function: log_text - Virtuoso Functions Guide" />
  <meta name="dc.subject" content="Function: log_text - Virtuoso Functions Guide" />
  <meta name="dc.creator" content="OpenLink Software Documentation Team ;&#10;" />
  <meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
  <link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
  <link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
  <link rel="parent" href="functions.html" title="Chapter Contents" />
  <link rel="prev" href="appendixa.html" title="Appendix" />
  <link rel="next" href="functions.html#.html" title="" />
  <link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
  <link rel="stylesheet" type="text/css" href="doc.css" />
  <link rel="stylesheet" type="text/css" href="/doc/translation.css" />
  <title>Function: log_text - Virtuoso Functions Guide</title>
  <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
  <meta name="author" content="OpenLink Software Documentation Team ;&#10;" />
  <meta name="copyright" content="OpenLink Software, 1999 - 2009" />
  <meta name="keywords" content="" />
  <meta name="GENERATOR" content="OpenLink XSLT Team" />
 </head>
 <body>
  <div id="header">
    <a name="fn_log_text" />
    <img src="../images/misc/logo.jpg" alt="" />
    <h1>22. Virtuoso Functions Guide - log_text</h1>
  </div>
  <div id="navbartop">
   <div>
      <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_log_enable.html" title="log_enable">Prev</a> | <a class="link" href="fn_dbf_set.html" title="__dbf_set">Next</a>
   </div>
  </div>
  <div id="currenttoc">
   <form method="post" action="/doc/adv_search.vspx">
    <div class="search">Keyword Search: <br />
        <input type="text" name="q" /> <input type="submit" name="go" value="Go" />
    </div>
   </form>
   <div>
      <a href="http://www.openlinksw.com/">www.openlinksw.com</a>
   </div>
   <div>
      <a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
   </div>
    <br />
   <div>
      <a href="index.html">Book Home</a>
   </div>
    <br />
   <div>
      <a href="contents.html">Contents</a>
   </div>
   <div>
      <a href="preface.html">Preface</a>
   </div>
    <br />
   <div>
      <a class="selected" href="functions.html">Virtuoso Functions Guide</a>
   </div>
    <br />
   <div>
      <a class="selected" href="functions.html#admin">Administration</a>
   </div>
   <div class="selected">
    <div>
        <a href="fn_vacuum.html">db.dba.vacuum</a>
    </div>
    <div>
        <a href="fn_USER_CHANGE_PASSWORD.html">user_change_password</a>
    </div>
    <div>
        <a href="fn_USER_CREATE.html">user_create</a>
    </div>
    <div>
        <a href="fn_USER_DROP.html">user_drop</a>
    </div>
    <div>
        <a href="fn_USER_GET_OPTION.html">user_get_option</a>
    </div>
    <div>
        <a href="fn_USER_GRANT_ROLE.html">user_grant_role</a>
    </div>
    <div>
        <a href="fn_USER_REVOKE_ROLE.html">user_revoke_role</a>
    </div>
    <div>
        <a href="fn_USER_ROLE_CREATE.html">user_role_create</a>
    </div>
    <div>
        <a href="fn_USER_ROLE_DROP.html">user_role_drop</a>
    </div>
    <div>
        <a href="fn_USER_SET_OPTION.html">user_set_option</a>
    </div>
    <div>
        <a href="fn_USER_SET_QUALIFIER.html">user_set_qualifier</a>
    </div>
    <div>
        <a href="fn_dbf_set.html">__dbf_set</a>
    </div>
    <div>
        <a href="fn_cfg_item_count.html">cfg_item_count</a>
    </div>
    <div>
        <a href="fn_cfg_item_name.html">cfg_item_name</a>
    </div>
    <div>
        <a href="fn_cfg_item_value.html">cfg_item_value</a>
    </div>
    <div>
        <a href="fn_cfg_section_count.html">cfg_section_count</a>
    </div>
    <div>
        <a href="fn_cfg_section_name.html">cfg_section_name</a>
    </div>
    <div>
        <a href="fn_cfg_write.html">cfg_write</a>
    </div>
    <div>
        <a href="fn_checkpoint_interval.html">checkpoint_interval</a>
    </div>
    <div>
        <a href="fn_disconnect_user.html">disconnect_user</a>
    </div>
    <div>
        <a href="fn_fk_check_input_values.html">fk_check_input_value...</a>
    </div>
    <div>
        <a href="fn_key_estimate.html">key_estimate</a>
    </div>
    <div>
        <a href="fn_log_enable.html">log_enable</a>
    </div>
    <div>
        <a class="selected" href="fn_log_text.html">log_text</a>
    </div>
    <div>
        <a href="fn_prof_enable.html">prof_enable</a>
    </div>
    <div>
        <a href="fn_prof_sample.html">prof_sample</a>
    </div>
    <div>
        <a href="fn_server_root.html">server_root</a>
    </div>
    <div>
        <a href="fn_status.html">status</a>
    </div>
    <div>
        <a href="fn_sys_lockdown.html">sys_lockdown</a>
    </div>
    <div>
        <a href="fn_sys_stat.html">sys_stat</a>
    </div>
    <div>
        <a href="fn_system.html">system</a>
    </div>
    <div>
        <a href="fn_trace_status.html">trace_status</a>
    </div>
    <div>
        <a href="fn_user_set_password.html">user_set_password</a>
    </div>
    <div>
        <a href="fn_virtuoso_ini_path.html">virtuoso_ini_path</a>
    </div>
   </div>
   <div>
      <a href="functions.html#aggr">Aggregate Functions</a>
   </div>
   <div>
      <a href="functions.html#array">Array Manipulation</a>
   </div>
   <div>
      <a href="functions.html#bpel">BPEL APIs</a>
   </div>
   <div>
      <a href="functions.html#backup">Backup</a>
   </div>
   <div>
      <a href="functions.html#compression">Compression</a>
   </div>
   <div>
      <a href="functions.html#cursors">Cursor</a>
   </div>
   <div>
      <a href="functions.html#time">Date &amp; Time Manipulation</a>
   </div>
   <div>
      <a href="functions.html#debug">Debug</a>
   </div>
   <div>
      <a href="functions.html#dict">Dictionary Manipulation</a>
   </div>
   <div>
      <a href="functions.html#encoding">Encoding &amp; Decoding</a>
   </div>
   <div>
      <a href="functions.html#file">File Manipulation</a>
   </div>
   <div>
      <a href="functions.html#ft">Free Text</a>
   </div>
   <div>
      <a href="functions.html#hash">Hashing / Cryptographic</a>
   </div>
   <div>
      <a href="functions.html#ldap">LDAP</a>
   </div>
   <div>
      <a href="functions.html#localization">Locale</a>
   </div>
   <div>
      <a href="functions.html#mail">Mail</a>
   </div>
   <div>
      <a href="functions.html#misc">Miscellaneous</a>
   </div>
   <div>
      <a href="functions.html#number">Number</a>
   </div>
   <div>
      <a href="functions.html#phrz">Phrases</a>
   </div>
   <div>
      <a href="functions.html#rdf">RDF data</a>
   </div>
   <div>
      <a href="functions.html#rmt">Remote SQL Data Source</a>
   </div>
   <div>
      <a href="functions.html#repl">Replication</a>
   </div>
   <div>
      <a href="functions.html#soap">SOAP</a>
   </div>
   <div>
      <a href="functions.html#sql">SQL</a>
   </div>
   <div>
      <a href="functions.html#string">String</a>
   </div>
   <div>
      <a href="functions.html#txn">Transaction</a>
   </div>
   <div>
      <a href="functions.html#type">Type Mapping</a>
   </div>
   <div>
      <a href="functions.html#uddi">UDDI</a>
   </div>
   <div>
      <a href="functions.html#udt">User Defined Types &amp; The CLR</a>
   </div>
   <div>
      <a href="functions.html#vad">VAD</a>
   </div>
   <div>
      <a href="functions.html#jvmpl">Virtuoso Java PL API</a>
   </div>
   <div>
      <a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
   </div>
   <div>
      <a href="functions.html#ws">Web &amp; Internet</a>
   </div>
   <div>
      <a href="functions.html#xml">XML</a>
   </div>
   <div>
      <a href="functions.html#XPATH">XPATH &amp; XQUERY</a>
   </div>
    <br />
   <div>
      <a href="functionidx.html">Functions Index</a>
   </div>
    <br />
  </div>
  <div id="text">
    <h2>log_text</h2>
    <div class="refpurpose">inserts statements into the roll forward log</div>
    <div class="funcsynopsis">
        <span class="funcdef">
     <span class="function">log_text</span>
     </span>
        (<span class="paramdef">in <span class="parameter">text</span> varchar</span>, 
        <span class="paramdefoptional">[in <span class="optional">arg_1</span> any]</span>, 
        <span class="paramdefoptional">[<span class="optional">...</span>]</span>);
      </div>
  
  
  
  <div class="refsect1">
      <div class="refsect1title">Description</div>
    <p>The log_text function can be used to insert a SQL statement
    into the roll forward log.</p>
    <p>The log_text function causes the SQL text given as first argument to
    be executed at roll forward time with the following arguments as parameters,
    bound from left to right to the parameter markers in the statement (&#39;?&#39;).
    There can be a maximum of 8 parameters but these can be arrays.</p>
  </div>
  <div class="refsect1">
      <div class="refsect1title">Parameters</div>
    <div class="refsect2">
        <span class="refsect2title">text – </span>
      <span class="computeroutput">VARCHAR</span>SQL statement to be added in the
      transaction log.
    </div>
    <div class="refsect2">
        <span class="refsect2title">arg1..arg8 – </span>
      Parameters to be passed to logged statement.
    </div>
  </div>
  <div class="refsect1">
      <div class="refsect1title">Examples</div>
    <a name="ex_log_text_1" />
      <div class="example">
        <div class="exampletitle">Log a procedure call</div>
    <p>Log a procedure call instead of its effects.</p>
    <div>
          <pre class="screen">
create procedure xx ()
{
  log_text (&#39;xx (?)&#39;, arg);
  log_enable (0);
  ... action code
  log_enable (1);
}
</pre>
        </div>
  </div>
  </div>
  <div class="refsect1">
      <div class="refsect1title">See Also</div>
    <p>
        <a href="fn_log_enable.html">log_enable</a>
      </p>
  </div>
</div>
  <div id="footer">
    <div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
   <div id="validation">
    <a href="http://validator.w3.org/check/referer">
        <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
    </a>
    <a href="http://jigsaw.w3.org/css-validator/">
        <img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
    </a>
   </div>
  </div>
 </body>
</html>

Perl :: Catalyst :: PostgreSQL :: RPM Valid HTML 4.01 Transitional