cvs: phpdoc /en/reference/oracle/functions ora-bind.xml

dams Sat May 17 09:32:13 2003 EDT Modified files: /phpdoc/en/reference/oracle/functions ora-bind.xml Log: no space in paramters + add ons Index: phpdoc/en/reference/oracle/functions/ora-bind.xml diff -u phpdoc/en/reference/oracle/functions/ora-bind.xml:1.2 phpdoc/en/reference/oracle/functions/ora-bind.xml:1.3 --- phpdoc/en/reference/oracle/functions/ora-bind.xml:1.2 Wed Apr 17 02:42:28 2002 +++ phpdoc/en/reference/oracle/functions/ora-bind.xml Sat May 17 09:32:13 2003 @@ -1,18 +1,18 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.2 $ --> +<!-- $Revision: 1.3 $ --> <!-- splitted from ./en/functions/oracle.xml, last change in rev 1.2 --> <refentry id="function.ora-bind"> <refnamediv> <refname>Ora_Bind</refname> - <refpurpose>bind a PHP variable to an Oracle parameter</refpurpose> + <refpurpose>Binds a PHP variable to an Oracle parameter</refpurpose> </refnamediv> <refsect1> <title>Description</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>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> @@ -31,26 +31,27 @@ ORA_BIND_OUT instead of the numbers. </para> <para> - ora_bind must be called after <function>ora_parse</function> and - before <function>ora_exec</function>. Input values can be given + <function>ora_bind</function> must be called after <function>ora_parse</function> + and before <function>ora_exec</function>. Input values can be given by assignment to the bound PHP variables, after calling <function>ora_exec</function> the bound PHP variables contain the output values if available. - <informalexample> + <example> + <title><function>ora_bind</function> example</title> <programlisting role="php"> <![CDATA[ <?php -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"; + 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> + </example> </para> </refsect1> </refentry>