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
-->
