cvs: phpdoc /ro/functions oracle.xml
| From: | Adrian Ciutureanu | Date: | Wed, 27 Mar 2002 08:32:07 +0000 |
| Subject: | cvs: phpdoc /ro/functions oracle.xml | ||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969343581@lists.php.net to get a copy of this message | ||
adu Wed Mar 27 03:32:07 2002 EDT
Added files:
/phpdoc/ro/functions oracle.xml
Log:
Oracle functions - Romanian version
Index: phpdoc/ro/functions/oracle.xml +++ phpdoc/ro/functions/oracle.xml <?xml version="1.0" encoding="iso-8859-2"?> <!-- $Revision: 1.1 $ --> <reference id="ref.oracle"> <title>Oracle</title> <titleabbrev>Oracle</titleabbrev> <refentry id="function.ora-bind"> <refnamediv> <refname>Ora_Bind</refname> <refpurpose>Leagã o variabilã PHP variable la un parametru Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_bind</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>string</type><parameter>PHP variable name</parameter></methodparam> <methodparam><type>string</type><parameter>SQL parameter name</parameter></methodparam> <methodparam><type>int</type><parameter>length</parameter></methodparam> <methodparam choice="opt"><type>int</type><parameter>type</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã legarea s-a efectuat, altfel returneazã &false;. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie leagã o variabilã PHP cu un parametru SQL. Paratetrul SQL trebuie sã fie sub forma ":name". Prin folosirea parametrului opþional <parameter>type</parameter>, puteþi defini dacã parametrul SQL este de tip intrare/ieºire (0, implicit), de tip intrare (1) sau de tip ieºire (2). Începând cu PHP 3.0.1, puteþi folosi constantele ORA_BIND_INOUT, ORA_BIND_IN ºi ORA_BIND_OUT în loc de numere. </para> <para> <function>ora_bind</function> trebuie apelatã dupã <function>ora_parse </function> ºi înainte de <function>ora_exec</function>. Valorile de intrare pot fi date prin asignarea lor variabilei PHP legate, dupã apelarea <function>ora_exec</function> variabilele PHP legate conþinând valorile de ieºire, dacã acestea existã. <informalexample> <programlisting role="php"> <![CDATA[ ora_parse($curs, "declare tmp INTEGER; begin tmp := :in; :out := tmp; :x := 7.77; end;"); ora_bind($curs, "result", ":x", $len, 2); ora_bind($curs, "input", ":in", 5, 1); ora_bind($curs, "output", ":out", 5, 2); $input = 765; ora_exec($curs); echo "Result: $result<BR>Out: $output<BR>In: $input"; ]]> </programlisting> </informalexample> </para> </refsect1> </refentry> <refentry id="function.ora-close"> <refnamediv> <refname>Ora_Close</refname> <refpurpose>Închide un cursor Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_close</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã închiderea a reuºit, altfel returneazã &false;. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie închide un cursor de date deschis cu <function>ora_open</function>. </para> </refsect1> </refentry> <refentry id="function.ora-columnname"> <refnamediv> <refname>Ora_ColumnName</refname> <refpurpose>Întoarce numele unei coloane dintr-un rezultat Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>string</type><methodname>Ora_ColumnName</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã numele coloanei/câmpului <parameter>column</parameter> din cursorul <parameter>cursor</parameter>. Valoarea returnatã este formatã din majuscule. Coloana 0 este prima coloanã. </para> </refsect1> </refentry> <refentry id="function.ora-columnsize"> <refnamediv> <refname>Ora_ColumnSize</refname> <refpurpose>Returneazã dimensiunea unei coloane dintr-un rezultat Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>Ora_ColumnSize</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã dimensiunea coloanei <parameter>column</parameter> din cursorul <parameter>cursor</parameter>. Coloana 0 este prima coloanã. </para> </refsect1> </refentry> <refentry id="function.ora-columntype"> <refnamediv> <refname>Ora_ColumnType</refname> <refpurpose>Returneazã tipul unei coloane dintr-un rezultat Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>string</type><methodname>Ora_ColumnType</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã numele tipului de datã Oracle a coloanei/câmpului <parameter>column</parameter> din cursorul <parameter>cursor</parameter>. Coloana 0 este prima coloanã. Tipul returnat va fi unul dintre urmãtoarele: <simplelist> <member><literal>"VARCHAR2"</literal></member> <member><literal>"VARCHAR"</literal></member> <member><literal>"CHAR"</literal></member> <member><literal>"NUMBER"</literal></member> <member><literal>"LONG"</literal></member> <member><literal>"LONG RAW"</literal></member> <member><literal>"ROWID"</literal></member> <member><literal>"DATE"</literal></member> <member><literal>"CURSOR"</literal></member> </simplelist> </para> </refsect1> </refentry> <refentry id="function.ora-commit"> <refnamediv> <refname>Ora_Commit</refname> <refpurpose>Valideazã o tranzacþie Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_commit</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã validarea a avut loc cu succes, &false; în caz de eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie valideazã o tranzacþie Oracle. O tranzacþie se defineºte ca mulþimea tuturor modificãrilor fãcute prin intermediul unei conexiuni de la ultimul apel commit/rollback, de la inactivarea setãrii autocommit sau de la momentul în care conexiunea a fost stabilitã. </para> </refsect1> </refentry> <refentry id="function.ora-commitoff"> <refnamediv> <refname>Ora_CommitOff</refname> <refpurpose>Dezactiveazã validarea automatã</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_commitoff</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã dezactivearea a avut loc cu succes, &false; dacã a apãrut eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie dezactiveazã validarea automatã (care s-ar efectua dupã apelul <function>ora_exec</function>). </para> </refsect1> </refentry> <refentry id="function.ora-commiton"> <refnamediv> <refname>Ora_CommitOn</refname> <refpurpose>Activeazã validarea automatã</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_commiton</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie activeazã validarea automatã, care se va efectua dupã fiecare apel <function>ora_exec</function> pentru conexiunea datã. </para> <para> Returneazã &true; dacã activarea a avut loc cu succes, &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> <refentry id="function.ora-do"> <refnamediv> <refname>Ora_Do</refname> <refpurpose>Parse, Exec, Fetch</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_do</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie este o combinaþie rapidã a funcþiilor <function>ora_parse</function>, <function>ora_exec</function> ºi <function>ora_fetch</function>. Ea va parsa o instrucþiune, o va executa ºi va returna prima linie a rezultatului. </para> <para> Returneazã &true; dacã totul decurge normal ºi &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, ºi <function>ora_fetch</function>. </para> </refsect1> </refentry> <refentry id="function.ora-error"> <refnamediv> <refname>Ora_Error</refname> <refpurpose>Returneazã un mesaj de eroare Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>string</type><methodname>Ora_Error</methodname> <methodparam><type>int</type><parameter>cursor_or_connection</parameter></methodparam> </methodsynopsis> <para> Returneazã un mesaj de eroare în formatul <replaceable>XXX</replaceable>-<replaceable>NNNNN</replaceable> unde <replaceable>XXX</replaceable> reprezintã sursa mesajului de eroare iar <replaceable>NNNNN</replaceable> identificã mesajul de eroare. </para> <para> <note> <para>Identificatorii de conexiuni sunt acceptaþi începând cu versiunea PHP 3.0.4.</para> </note> </para> <para> În versiunile UNIX pentru Oracle, detaliile despre o eroare apar sub forma urmãtoare: <computeroutput> $ <userinput>oerr ora <replaceable>00001</replaceable></userinput> 00001, 00000, "unique constraint (%s.%s) violated" // *Cause: An update or insert statement attempted to insert a duplicate key // For Trusted ORACLE configured in DBMS MAC mode, you may see // this message if a duplicate entry exists at a different level. // *Action: Either remove the unique restriction or do not insert the key </computeroutput> </para> </refsect1> </refentry> <refentry id="function.ora-errorcode"> <refnamediv> <refname>Ora_ErrorCode</refname> <refpurpose>Returneazã codul unei erori Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>Ora_ErrorCode</methodname> <methodparam><type>int</type><parameter>cursor_or_connection</parameter></methodparam> </methodsynopsis> <para> Returneazã codul numeric al execuþiei ultimei instrucþiuni asupra cursorului sau al conexiunii specificate. <!-- FIXME: should possible values be listed? --> <note> <para>Identificatorii de conexiuni sunt acceptaþi începând cu versiunea PHP 3.0.4.</para> </note> </para> </refsect1> </refentry> <refentry id="function.ora-exec"> <refnamediv> <refname>Ora_Exec</refname> <refpurpose>Executã o instrucþiune parsatã asupra unui cursor Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_exec</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã execuþia are loc cu succes, &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-fetch"> <refnamediv> <refname>Ora_Fetch</refname> <refpurpose>Extrage o linie de date dintr-un cursor</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_fetch</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã s-a extras o linie sau &false; dacã nu mai existã linii sau în caz de eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. Dacã nu a apãrut nici o eroare, <function>ora_errorcode</function> va returna 0. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-fetch-into"> <refnamediv> <refname>Ora_Fetch_Into</refname> <refpurpose>Extrage o linie de date într-un tablou</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_fetch_into</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>array</type><parameter>result</parameter></methodparam> <methodparam choice="opt"><type>int</type><parameter> flags </parameter></methodparam> </methodsynopsis> <para> Cu aceastã puteþi extrage o linie de date într-un tablou. <example> <programlisting role="php"> <![CDATA[ array($results); ora_fetch_into($cursor, &$results); echo $results[0]; echo $results[1]; ]]> </programlisting> </example> De notat cã tabloul trebuie trimis ca referinþã. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-getcolumn"> <refnamediv> <refname>Ora_GetColumn</refname> <refpurpose>Returneazã datele dintr-o coloanã extrasã</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>mixed</type><methodname>ora_getcolumn</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>mixed</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã datele dintr-o coloanã. Dacã apare eroare, se returneazã &false; ºi <function>ora_errorcode</function> va returna o valoare diferitã de zero. De notat cã este posibil ca <function>ora_getcolumn</function> sã returneze un ºir de caractere vid, întregul 0 sau ºirul de caractere "0", caz în care testul cu &false; returneazã &true;. </para> </refsect1> </refentry> <refentry id="function.ora-logoff"> <refnamediv> <refname>Ora_Logoff</refname> <refpurpose>Închide o conexiune Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_logoff</methodname> <methodparam><type>int</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; în caz de succes, &false; dacã apare eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Executã logout pentru utilizator ºi închide conexiunea la server. </para> <simpara> Mai consultaþi <function>ora_logon</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-logon"> <refnamediv> <refname>Ora_Logon</refname> <refpurpose>Iniþiazã o conexiune Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_logon</methodname> <methodparam><type>string</type><parameter>user</parameter></methodparam> <methodparam><type>string</type><parameter>password</parameter></methodparam> </methodsynopsis> <para> Stabileºte o conexiune între PHP ºi Oracle pe baza parametrilor <parameter>user</parameter> (nume utilizator) ºi <parameter>password</parameter> (parola). </para> <para> Conexiunea poate fi stabilitã folosind <productname>SQL*Net</productname> prin furnizarea numelui <acronym>TNS</acronym> în maniera urmãtoare: <informalexample> <programlisting role="php"> $conn = ora_logon("user<emphasis>@TNSNAME</emphasis>", "pass"); </programlisting> </informalexample> </para> <para> Dacã aveþi date care conþin caractere non-ASCII, trebuie sã vã asiguraþi cã variabila de mediu <envar>NLS_LANG</envar> este setatã corect. Pentru modulele de server, aceastã variabilã trebuie setatã înainte de pornirea serverului. </para> <para> Returneazã indexul unei conexiuni în cazul în care totul decurge normal ºi &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> <refentry id="function.ora-plogon"> <refnamediv> <refname>Ora_pLogon</refname> <refpurpose> Iniþiazã o conexiune permanentã Oracle </refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_plogon</methodname> <methodparam><type>string</type><parameter>user</parameter></methodparam> <methodparam><type>string</type><parameter>password</parameter></methodparam> </methodsynopsis> <para> Stabileºte o conexiune permanentã între PHP ºi Oracle pe baza parametrilor <parameter>user</parameter> (nume utilizator) ºi <parameter>password</parameter> (parola). </para> <simpara> Mai consultaþi <function>ora_logon</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-numcols"> <refnamediv> <refname>Ora_Numcols</refname> <refpurpose>Returneazã numãrul de coloane</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_numcols</methodname> <methodparam><type>int</type><parameter>cursor_ind</parameter></methodparam> </methodsynopsis> <para> <function>ora_numcols</function> returneazã numãrul de coloane dintr-un rezultat. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. Valoarea returnatã este semnificativã doar dupã o secvenþã parse/exec/fetch. </simpara> </refsect1> </refentry> <refentry id="function.ora-numrows"> <refnamediv> <refname>Ora_Numrows</refname> <refpurpose>Returneazã numãrul de linii</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_numrows</methodname> <methodparam><type>int</type><parameter>cursor_ind</parameter></methodparam> </methodsynopsis> <para> <function>ora_numrows</function> returneazã numãrul de linii dintr-un rezultat. </para> </refsect1> </refentry> <refentry id="function.ora-open"> <refnamediv> <refname>Ora_Open</refname> <refpurpose>Deschide un cursor Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_open</methodname> <methodparam><type>int</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> Deschide un cursor Oracle asociat cu o conexiune. </para> <para> Returneazã a un index de cursor index sau &false; în caz de eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> <refentry id="function.ora-parse"> <refnamediv> <refname>Ora_Parse</refname> <refpurpose>Parseazã o instrucþiune SQL</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_parse</methodname> <methodparam><type>int</type><parameter>cursor_ind</parameter></methodparam> <methodparam><type>string</type><parameter>sql_statement</parameter></methodparam> <methodparam><type>int</type><parameter>defer</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie parseazã o instrucþiune SQL sau un bloc de instrucþuni PL/SQL ºi asociazã aceasta cu un cursor. </para> <para> &return.success; </para> <simpara> Mai consultaþi <function>ora_exec</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-rollback"> <refnamediv> <refname>Ora_Rollback</refname> <refpurpose>Anuleazã o tranzacþie</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_rollback</methodname> <methodparam><type>int</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie anuleazã o tranzacþie Oracle. Consultaþi <function>ora_commit</function> pentru definiþia tranzacþiei. </para> <para> Returneazã &true; dacã totul decurge normal ºi &false; dacã apare eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> </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 -->
Index: phpdoc/ro/functions/oracle.xml +++ phpdoc/ro/functions/oracle.xml <?xml version="1.0" encoding="iso-8859-2"?> <!-- $Revision: 1.1 $ --> <reference id="ref.oracle"> <title>Oracle</title> <titleabbrev>Oracle</titleabbrev> <refentry id="function.ora-bind"> <refnamediv> <refname>Ora_Bind</refname> <refpurpose>Leagã o variabilã PHP variable la un parametru Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_bind</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>string</type><parameter>PHP variable name</parameter></methodparam> <methodparam><type>string</type><parameter>SQL parameter name</parameter></methodparam> <methodparam><type>int</type><parameter>length</parameter></methodparam> <methodparam choice="opt"><type>int</type><parameter>type</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã legarea s-a efectuat, altfel returneazã &false;. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie leagã o variabilã PHP cu un parametru SQL. Paratetrul SQL trebuie sã fie sub forma ":name". Prin folosirea parametrului opþional <parameter>type</parameter>, puteþi defini dacã parametrul SQL este de tip intrare/ieºire (0, implicit), de tip intrare (1) sau de tip ieºire (2). Începând cu PHP 3.0.1, puteþi folosi constantele ORA_BIND_INOUT, ORA_BIND_IN ºi ORA_BIND_OUT în loc de numere. </para> <para> <function>ora_bind</function> trebuie apelatã dupã <function>ora_parse </function> ºi înainte de <function>ora_exec</function>. Valorile de intrare pot fi date prin asignarea lor variabilei PHP legate, dupã apelarea <function>ora_exec</function> variabilele PHP legate conþinând valorile de ieºire, dacã acestea existã. <informalexample> <programlisting role="php"> <![CDATA[ ora_parse($curs, "declare tmp INTEGER; begin tmp := :in; :out := tmp; :x := 7.77; end;"); ora_bind($curs, "result", ":x", $len, 2); ora_bind($curs, "input", ":in", 5, 1); ora_bind($curs, "output", ":out", 5, 2); $input = 765; ora_exec($curs); echo "Result: $result<BR>Out: $output<BR>In: $input"; ]]> </programlisting> </informalexample> </para> </refsect1> </refentry> <refentry id="function.ora-close"> <refnamediv> <refname>Ora_Close</refname> <refpurpose>Închide un cursor Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_close</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã închiderea a reuºit, altfel returneazã &false;. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie închide un cursor de date deschis cu <function>ora_open</function>. </para> </refsect1> </refentry> <refentry id="function.ora-columnname"> <refnamediv> <refname>Ora_ColumnName</refname> <refpurpose>Întoarce numele unei coloane dintr-un rezultat Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>string</type><methodname>Ora_ColumnName</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã numele coloanei/câmpului <parameter>column</parameter> din cursorul <parameter>cursor</parameter>. Valoarea returnatã este formatã din majuscule. Coloana 0 este prima coloanã. </para> </refsect1> </refentry> <refentry id="function.ora-columnsize"> <refnamediv> <refname>Ora_ColumnSize</refname> <refpurpose>Returneazã dimensiunea unei coloane dintr-un rezultat Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>Ora_ColumnSize</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã dimensiunea coloanei <parameter>column</parameter> din cursorul <parameter>cursor</parameter>. Coloana 0 este prima coloanã. </para> </refsect1> </refentry> <refentry id="function.ora-columntype"> <refnamediv> <refname>Ora_ColumnType</refname> <refpurpose>Returneazã tipul unei coloane dintr-un rezultat Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>string</type><methodname>Ora_ColumnType</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>int</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã numele tipului de datã Oracle a coloanei/câmpului <parameter>column</parameter> din cursorul <parameter>cursor</parameter>. Coloana 0 este prima coloanã. Tipul returnat va fi unul dintre urmãtoarele: <simplelist> <member><literal>"VARCHAR2"</literal></member> <member><literal>"VARCHAR"</literal></member> <member><literal>"CHAR"</literal></member> <member><literal>"NUMBER"</literal></member> <member><literal>"LONG"</literal></member> <member><literal>"LONG RAW"</literal></member> <member><literal>"ROWID"</literal></member> <member><literal>"DATE"</literal></member> <member><literal>"CURSOR"</literal></member> </simplelist> </para> </refsect1> </refentry> <refentry id="function.ora-commit"> <refnamediv> <refname>Ora_Commit</refname> <refpurpose>Valideazã o tranzacþie Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_commit</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã validarea a avut loc cu succes, &false; în caz de eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie valideazã o tranzacþie Oracle. O tranzacþie se defineºte ca mulþimea tuturor modificãrilor fãcute prin intermediul unei conexiuni de la ultimul apel commit/rollback, de la inactivarea setãrii autocommit sau de la momentul în care conexiunea a fost stabilitã. </para> </refsect1> </refentry> <refentry id="function.ora-commitoff"> <refnamediv> <refname>Ora_CommitOff</refname> <refpurpose>Dezactiveazã validarea automatã</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_commitoff</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã dezactivearea a avut loc cu succes, &false; dacã a apãrut eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Aceastã funcþie dezactiveazã validarea automatã (care s-ar efectua dupã apelul <function>ora_exec</function>). </para> </refsect1> </refentry> <refentry id="function.ora-commiton"> <refnamediv> <refname>Ora_CommitOn</refname> <refpurpose>Activeazã validarea automatã</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_commiton</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie activeazã validarea automatã, care se va efectua dupã fiecare apel <function>ora_exec</function> pentru conexiunea datã. </para> <para> Returneazã &true; dacã activarea a avut loc cu succes, &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> <refentry id="function.ora-do"> <refnamediv> <refname>Ora_Do</refname> <refpurpose>Parse, Exec, Fetch</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_do</methodname> <methodparam><type>int</type><parameter>conn</parameter></methodparam> <methodparam><type>string</type><parameter>query</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie este o combinaþie rapidã a funcþiilor <function>ora_parse</function>, <function>ora_exec</function> ºi <function>ora_fetch</function>. Ea va parsa o instrucþiune, o va executa ºi va returna prima linie a rezultatului. </para> <para> Returneazã &true; dacã totul decurge normal ºi &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, ºi <function>ora_fetch</function>. </para> </refsect1> </refentry> <refentry id="function.ora-error"> <refnamediv> <refname>Ora_Error</refname> <refpurpose>Returneazã un mesaj de eroare Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>string</type><methodname>Ora_Error</methodname> <methodparam><type>int</type><parameter>cursor_or_connection</parameter></methodparam> </methodsynopsis> <para> Returneazã un mesaj de eroare în formatul <replaceable>XXX</replaceable>-<replaceable>NNNNN</replaceable> unde <replaceable>XXX</replaceable> reprezintã sursa mesajului de eroare iar <replaceable>NNNNN</replaceable> identificã mesajul de eroare. </para> <para> <note> <para>Identificatorii de conexiuni sunt acceptaþi începând cu versiunea PHP 3.0.4.</para> </note> </para> <para> În versiunile UNIX pentru Oracle, detaliile despre o eroare apar sub forma urmãtoare: <computeroutput> $ <userinput>oerr ora <replaceable>00001</replaceable></userinput> 00001, 00000, "unique constraint (%s.%s) violated" // *Cause: An update or insert statement attempted to insert a duplicate key // For Trusted ORACLE configured in DBMS MAC mode, you may see // this message if a duplicate entry exists at a different level. // *Action: Either remove the unique restriction or do not insert the key </computeroutput> </para> </refsect1> </refentry> <refentry id="function.ora-errorcode"> <refnamediv> <refname>Ora_ErrorCode</refname> <refpurpose>Returneazã codul unei erori Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>Ora_ErrorCode</methodname> <methodparam><type>int</type><parameter>cursor_or_connection</parameter></methodparam> </methodsynopsis> <para> Returneazã codul numeric al execuþiei ultimei instrucþiuni asupra cursorului sau al conexiunii specificate. <!-- FIXME: should possible values be listed? --> <note> <para>Identificatorii de conexiuni sunt acceptaþi începând cu versiunea PHP 3.0.4.</para> </note> </para> </refsect1> </refentry> <refentry id="function.ora-exec"> <refnamediv> <refname>Ora_Exec</refname> <refpurpose>Executã o instrucþiune parsatã asupra unui cursor Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_exec</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã execuþia are loc cu succes, &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-fetch"> <refnamediv> <refname>Ora_Fetch</refname> <refpurpose>Extrage o linie de date dintr-un cursor</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_fetch</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; dacã s-a extras o linie sau &false; dacã nu mai existã linii sau în caz de eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. Dacã nu a apãrut nici o eroare, <function>ora_errorcode</function> va returna 0. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-fetch-into"> <refnamediv> <refname>Ora_Fetch_Into</refname> <refpurpose>Extrage o linie de date într-un tablou</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_fetch_into</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>array</type><parameter>result</parameter></methodparam> <methodparam choice="opt"><type>int</type><parameter> flags </parameter></methodparam> </methodsynopsis> <para> Cu aceastã puteþi extrage o linie de date într-un tablou. <example> <programlisting role="php"> <![CDATA[ array($results); ora_fetch_into($cursor, &$results); echo $results[0]; echo $results[1]; ]]> </programlisting> </example> De notat cã tabloul trebuie trimis ca referinþã. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-getcolumn"> <refnamediv> <refname>Ora_GetColumn</refname> <refpurpose>Returneazã datele dintr-o coloanã extrasã</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>mixed</type><methodname>ora_getcolumn</methodname> <methodparam><type>int</type><parameter>cursor</parameter></methodparam> <methodparam><type>mixed</type><parameter>column</parameter></methodparam> </methodsynopsis> <para> Returneazã datele dintr-o coloanã. Dacã apare eroare, se returneazã &false; ºi <function>ora_errorcode</function> va returna o valoare diferitã de zero. De notat cã este posibil ca <function>ora_getcolumn</function> sã returneze un ºir de caractere vid, întregul 0 sau ºirul de caractere "0", caz în care testul cu &false; returneazã &true;. </para> </refsect1> </refentry> <refentry id="function.ora-logoff"> <refnamediv> <refname>Ora_Logoff</refname> <refpurpose>Închide o conexiune Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_logoff</methodname> <methodparam><type>int</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> Returneazã &true; în caz de succes, &false; dacã apare eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> <para> Executã logout pentru utilizator ºi închide conexiunea la server. </para> <simpara> Mai consultaþi <function>ora_logon</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-logon"> <refnamediv> <refname>Ora_Logon</refname> <refpurpose>Iniþiazã o conexiune Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_logon</methodname> <methodparam><type>string</type><parameter>user</parameter></methodparam> <methodparam><type>string</type><parameter>password</parameter></methodparam> </methodsynopsis> <para> Stabileºte o conexiune între PHP ºi Oracle pe baza parametrilor <parameter>user</parameter> (nume utilizator) ºi <parameter>password</parameter> (parola). </para> <para> Conexiunea poate fi stabilitã folosind <productname>SQL*Net</productname> prin furnizarea numelui <acronym>TNS</acronym> în maniera urmãtoare: <informalexample> <programlisting role="php"> $conn = ora_logon("user<emphasis>@TNSNAME</emphasis>", "pass"); </programlisting> </informalexample> </para> <para> Dacã aveþi date care conþin caractere non-ASCII, trebuie sã vã asiguraþi cã variabila de mediu <envar>NLS_LANG</envar> este setatã corect. Pentru modulele de server, aceastã variabilã trebuie setatã înainte de pornirea serverului. </para> <para> Returneazã indexul unei conexiuni în cazul în care totul decurge normal ºi &false; dacã apare o eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> <refentry id="function.ora-plogon"> <refnamediv> <refname>Ora_pLogon</refname> <refpurpose> Iniþiazã o conexiune permanentã Oracle </refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_plogon</methodname> <methodparam><type>string</type><parameter>user</parameter></methodparam> <methodparam><type>string</type><parameter>password</parameter></methodparam> </methodsynopsis> <para> Stabileºte o conexiune permanentã între PHP ºi Oracle pe baza parametrilor <parameter>user</parameter> (nume utilizator) ºi <parameter>password</parameter> (parola). </para> <simpara> Mai consultaþi <function>ora_logon</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-numcols"> <refnamediv> <refname>Ora_Numcols</refname> <refpurpose>Returneazã numãrul de coloane</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_numcols</methodname> <methodparam><type>int</type><parameter>cursor_ind</parameter></methodparam> </methodsynopsis> <para> <function>ora_numcols</function> returneazã numãrul de coloane dintr-un rezultat. </para> <simpara> Mai consultaþi <function>ora_parse</function>, <function>ora_exec</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. Valoarea returnatã este semnificativã doar dupã o secvenþã parse/exec/fetch. </simpara> </refsect1> </refentry> <refentry id="function.ora-numrows"> <refnamediv> <refname>Ora_Numrows</refname> <refpurpose>Returneazã numãrul de linii</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_numrows</methodname> <methodparam><type>int</type><parameter>cursor_ind</parameter></methodparam> </methodsynopsis> <para> <function>ora_numrows</function> returneazã numãrul de linii dintr-un rezultat. </para> </refsect1> </refentry> <refentry id="function.ora-open"> <refnamediv> <refname>Ora_Open</refname> <refpurpose>Deschide un cursor Oracle</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_open</methodname> <methodparam><type>int</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> Deschide un cursor Oracle asociat cu o conexiune. </para> <para> Returneazã a un index de cursor index sau &false; în caz de eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> <refentry id="function.ora-parse"> <refnamediv> <refname>Ora_Parse</refname> <refpurpose>Parseazã o instrucþiune SQL</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_parse</methodname> <methodparam><type>int</type><parameter>cursor_ind</parameter></methodparam> <methodparam><type>string</type><parameter>sql_statement</parameter></methodparam> <methodparam><type>int</type><parameter>defer</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie parseazã o instrucþiune SQL sau un bloc de instrucþuni PL/SQL ºi asociazã aceasta cu un cursor. </para> <para> &return.success; </para> <simpara> Mai consultaþi <function>ora_exec</function>, <function>ora_fetch</function> ºi <function>ora_do</function>. </simpara> </refsect1> </refentry> <refentry id="function.ora-rollback"> <refnamediv> <refname>Ora_Rollback</refname> <refpurpose>Anuleazã o tranzacþie</refpurpose> </refnamediv> <refsect1> <title>Descriere</title> <methodsynopsis> <type>int</type><methodname>ora_rollback</methodname> <methodparam><type>int</type><parameter>connection</parameter></methodparam> </methodsynopsis> <para> Aceastã funcþie anuleazã o tranzacþie Oracle. Consultaþi <function>ora_commit</function> pentru definiþia tranzacþiei. </para> <para> Returneazã &true; dacã totul decurge normal ºi &false; dacã apare eroare. Detalii despre eroare pot fi aflate folosind funcþiile <function>ora_error</function> ºi <function>ora_errorcode</function>. </para> </refsect1> </refentry> </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 -->