cvs: phpdoc-sk /reference/oci8 reference.xml

_batman_		Wed Apr  9 14:45:56 2003 EDT

  Added files:                 
    /phpdoc-sk/reference/oci8	reference.xml 
  Log:
  only copied
  
  

Index: phpdoc-sk/reference/oci8/reference.xml
+++ phpdoc-sk/reference/oci8/reference.xml
<?xml version="1.0" encoding="iso-8859-1"?>
<!-- $Revision: 1.1 $ -->
 <reference id="ref.oci8">
  <title>Oracle 8 functions</title>
  <titleabbrev>OCI8</titleabbrev>

  <partintro>
   <section id="oci8.intro">
    &reftitle.intro;
    <para>
     Tieto funkcie vam umoznia pristup k Oracle8 a Oracle7 databazam.
     Pouzivaju Oracle8 Call-Interface (OCI8)     
    </para>
    <para>
     Toto rozsirenie je flexibilnejsie ako
     <link linkend="ref.oracle">standardne Oracle</link>
     rozsirenie. Podporuje previazanie globalnych alebo lokalnych PHP
     a Oracle premennych, plna podpora LOB, FILE a ROWID a umoznuje 
     pouzivat uzivatelsky definovane premenne.
    </para>
   </section>

   <section id="oci8.requirements">
    &reftitle.required;
   <para>
    Na pouzivanie tohto rozsirenia budete potrebovat Oracle8 klientske
    kniznice.    
   </para>
   <para>
    Pred pouzivanim tychto funkcii sa uistite, ze mate korektne nastavenie
    premenne prostredia Oracle pre Oracle uzivatela, tak isto aj pre
    uzivatela, pod ktorym bezi vas webserver.
    Budete potrebovat nasledujuce premenne:    
    <itemizedlist>
     <listitem>
      <simpara>
       ORACLE_HOME
      </simpara>
     </listitem>
     <listitem>
      <simpara>
       ORACLE_SID
      </simpara>
     </listitem>
     <listitem>
      <simpara>
       LD_PRELOAD
      </simpara>
     </listitem>
     <listitem>
      <simpara>
       LD_LIBRARY_PATH
      </simpara>
     </listitem>
     <listitem>
      <simpara>
       NLS_LANG
      </simpara>
     </listitem>
     <listitem>
      <simpara>
       ORA_NLS33
      </simpara>
     </listitem>
    </itemizedlist>
   </para>
   <para>
    Po nastaveni premennych prostredia pre uzivatela, pod ktorym bezi
    webserver sa uistite, ze ste tohto uzivatela (nobody, www) pridali aj 
    do oracle skupiny.
   </para>
   <note>
    <title>Ak vas webserver nenabehne alebo padne hned po starte</title>
    <para>
     Skontrolujte, ci je Apache zlinkovany s pthread kniznicami:     
    </para>
    <para>
     <informalexample>
      <screen>
<![CDATA[
# ldd /www/apache/bin/httpd 
    libpthread.so.0 => /lib/libpthread.so.0 (0x4001c000)
    libm.so.6 => /lib/libm.so.6 (0x4002f000)
    libcrypt.so.1 => /lib/libcrypt.so.1 (0x4004c000)
    libdl.so.2 => /lib/libdl.so.2 (0x4007a000)
    libc.so.6 => /lib/libc.so.6 (0x4007e000)
    /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
]]>
      </screen>
     </informalexample>
    </para>
    <para>
     Ak libpthread nie je na vypise, musite preinstalovat Apache:
    </para>
    <para>
     <informalexample>
      <screen>
<![CDATA[
# cd /usr/src/apache_1.3.xx
# make clean
# LIBS=-lpthread ./config.status
# make
# make install
]]>
      </screen>
     </informalexample>
    </para>
    <para>
      Na niektorych UnixWare je kniznica libthread namiesto libpthread.
      V takom pripade musia byt PHP a Apache konfigurovane pomocou
      EXTRA_LIBS=-lthread.
    </para>
   </note>
   </section>

   &reference.oci8.configure;

   <section id="oci8.configuration">
    &reftitle.runtime;
    &no.config;
   </section>

   <section id="oci8.resources">
    &reftitle.resources;
    <para>
    </para>
   </section>

   &reference.oci8.constants;

   <section id="oci8.examples">
   &reftitle.examples;
    <para>
    <example>
     <title>OCI Hints</title>
      <programlisting role="php">
<![CDATA[
<?php
// by [email protected]

// Use option: OCI_DEFAULT for execute command to delay execution
OCIExecute($stmt, OCI_DEFAULT);

// for retrieve data use (after fetch):

$result = OCIResult($stmt, $n);
if (is_object ($result)) $result = $result->load();

// For INSERT or UPDATE statement use:

$sql = "insert into table (field1, field2) values (field1 = 'value',
 field2 = empty_clob()) returning field2 into :field2";
OCIParse($conn, $sql);
$clob = OCINewDescriptor($conn, OCI_D_LOB);
OCIBindByName ($stmt, ":field2", &$clob, -1, OCI_B_CLOB);
OCIExecute($stmt, OCI_DEFAULT);
$clob->save ("some text");
OCICommit($conn);

?>
]]>
     </programlisting>
    </example>
    </para>
    <para>
     Mozete lahko pristupovat k ulozenym proceduram rovnako ako keby ste k
     nim pristupovali z prikazoveho riadku.
    <example>
     <title>Using Stored Procedures</title>
      <programlisting role="php">
<![CDATA[
<?php
// by [email protected]
$sth = OCIParse ( $dbh, "begin sp_newaddress( :address_id, '$firstname',
 '$lastname', '$company', '$address1', '$address2', '$city', '$state',
 '$postalcode', '$country', :error_code );end;" );

// This calls stored procedure sp_newaddress, with :address_id being an
// in/out variable and :error_code being an out variable. 
// Then you do the binding:

   OCIBindByName ( $sth, ":address_id", $addr_id, 10 );
   OCIBindByName ( $sth, ":error_code", $errorcode, 10 );
   OCIExecute ( $sth );

?>
]]>
      </programlisting>
    </example>
    </para>
   </section>

  </partintro>

&reference.oci8.functions;

 </reference>
<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
indent-tabs-mode:nil
sgml-parent-document:nil
sgml-default-dtd-file:"../../../manual.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
vim600: syn=xml fen fdm=syntax fdl=2 si
vim: et tw=78 syn=sgml
vi: ts=1 sw=1
-->