cvs: phpdoc /it/functions oci8.xml
| From: | Marco Cucinato | Date: | Thu, 22 Nov 2001 11:04:04 +0000 |
| Subject: | cvs: phpdoc /it/functions oci8.xml | ||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969339127@lists.php.net to get a copy of this message | ||
cucinato Thu Nov 22 06:04:04 2001 EDT
Modified files:
/phpdoc/it/functions oci8.xml
Log:
Finished CDATA update
Index: phpdoc/it/functions/oci8.xml diff -u phpdoc/it/functions/oci8.xml:1.18 phpdoc/it/functions/oci8.xml:1.19 --- phpdoc/it/functions/oci8.xml:1.18 Wed Nov 21 16:56:21 2001 +++ phpdoc/it/functions/oci8.xml Thu Nov 22 06:04:04 2001 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> - <!-- EN-Revision: 1.35 Maintainer: cucinato Status: ready --> + <!-- EN-Revision: 1.36 Maintainer: cucinato Status: ready --> <reference id="ref.oci8"> <title>Funzioni Oracle 8</title> <titleabbrev>OCI8</titleabbrev> @@ -97,21 +97,21 @@ </note> <para> <example> - <title>OCI Hints</title> + <title>Trucchi OCI</title> <programlisting role="php"> <![CDATA[ <?php // by sergo@bacup.ru -// Use option: OCI_DEFAULT for execute command to delay execution +// Usare l'opzione OCI_DEFAULT nel comando execute per ritardare l'esicuzione OCIExecute($stmt, OCI_DEFAULT); -// for retrieve data use (after fetch): +// per ricevere i dati utilizzare (dopo il fetch): $result = OCIResult($stmt, $n); if (is_object ($result)) $result = $result->load(); -// For INSERT or UPDATE statement use: +// come comandi INSERT o UPDATE usare: $sql = "insert into table (field1, field2) values (field1 = 'value', field2 = empty_clob()) returning field2 into :field2"; @@ -132,27 +132,29 @@ would from the commands line. <example> <title>Using Stored Procedures</title> - <programlisting role="php"> -<?php + <programlisting role="php"> +<![CDATA[ +<?php // by webmaster@remoterealty.com $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: +// Questo codice richiama la stord procedure sp_newaddress, dove :address_id è +// una variabile in/out e :error_code è una variabile out. +// Quindi si effettua il binding: OCIBindByName ( $sth, ":address_id", $addr_id, 10 ); OCIBindByName ( $sth, ":error_code", $errorcode, 10 ); OCIExecute ( $sth ); -?> +?> +]]> </programlisting> </example> </para> </partintro> - + <refentry id="function.ocidefinebyname"> <refnamediv> <refname>OCIDefineByName</refname> @@ -190,14 +192,15 @@ <example> <title>OCIDefineByName</title> <programlisting> -<?php +<![CDATA[ +<?php /* OCIDefineByPos example thies@thieso.net (980219) */ $conn = OCILogon("scott","tiger"); $stmt = OCIParse($conn,"select empno, ename from emp"); -/* the define MUST be done BEFORE ociexecute! */ +/* il define DEVE essere eseguito PRIMA di ociexecute! */ OCIDefineByName($stmt,"EMPNO",$empno); OCIDefineByName($stmt,"ENAME",$ename); @@ -212,6 +215,7 @@ OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> </example> </refsect1> @@ -259,13 +263,14 @@ (Character-File), OCI_B_CLOB (Character-LOB), OCI_B_BLOB (Binary-LOB) e OCI_B_ROWID (ROWID). </para> - <example> - <title>OCIDefineByName</title> - <programlisting> -<?php + <example> + <title>OCIDefineByName</title> + <programlisting> +<![CDATA[ +<?php /* OCIBindByPos example thies@thieso.net (980221) - inserts 3 records into emp, and uses the ROWID for updating the - records just after the insert. + inserisce 3 tuple in emp, e usa ROWID per aggiornare le + tuple subito dopo l'inserimento. */ $conn = OCILogon("scott","tiger"); @@ -312,8 +317,9 @@ OCILogoff($conn); ?> - </programlisting> - </example> +]]> + </programlisting> + </example> <warning> <para> It is a bad idea to use magic quotes and @@ -363,8 +369,9 @@ <example> <title>OCILogon</title> <programlisting> -<?php -print "<HTML><PRE>"; +<![CDATA[ +<?php +print "<HTML><PRE>"; $db = ""; $c1 = ocilogon("scott","tiger",$db); @@ -410,7 +417,7 @@ ociexecute($stmt,OCI_DEFAULT); echo $conn."----selecting\n\n"; while (ocifetch($stmt)) - echo $conn." <".ociresult($stmt,"TEST").">\n\n"; + echo $conn." <".ociresult($stmt,"TEST").">\n\n"; echo $conn."----done\n\n"; } @@ -441,8 +448,12 @@ drop_table($c1); -print "</PRE></HTML>"; -?></programlisting></example></para> +print "</PRE></HTML>"; +?> +]]> + </programlisting> + </example> + </para> <simpara> Vedere anche <function>OCIPLogon</function> e <function>OCINLogon</function>.</simpara> @@ -462,9 +473,9 @@ <funcdef>int <function>OCIPLogon</function></funcdef> <paramdef>string <parameter>username</parameter></paramdef> <paramdef>string <parameter>password</parameter></paramdef> - <paramdef>string + <paramdef>string <parameter><optional>db</optional></parameter> - </paramdef> + </paramdef> </funcprototype> </funcsynopsis> <para> @@ -496,7 +507,7 @@ <funcdef>int <function>OCINLogon</function></funcdef> <paramdef>string <parameter>username</parameter></paramdef> <paramdef>string <parameter>password</parameter></paramdef> - <paramdef>string + <paramdef>string <parameter><optional>db</optional></parameter> </paramdef> </funcprototype> @@ -524,8 +535,9 @@ <example> <title>OCINLogon</title> <programlisting> -<?php -print "<HTML><PRE>"; +<![CDATA[ +<?php +print "<HTML><PRE>"; $db = ""; $c1 = ocilogon("scott","tiger",$db); @@ -572,7 +584,7 @@ ociexecute($stmt,OCI_DEFAULT); echo $conn."----selecting\n\n"; while (ocifetch($stmt)) - echo $conn." <".ociresult($stmt,"TEST").">\n\n"; + echo $conn." <".ociresult($stmt,"TEST").">\n\n"; echo $conn."----done\n\n"; } @@ -602,8 +614,11 @@ drop_table($c1); -print "</PRE></HTML>"; -?></programlisting></example> +print "</PRE></HTML>"; +?> +]]> + </programlisting> + </example> </para> <simpara> Vedere anche <function>OCILogon</function> e @@ -642,7 +657,7 @@ <funcprototype> <funcdef>int <function>OCIExecute</function></funcdef> <paramdef>int <parameter>statement</parameter></paramdef> - <paramdef>int + <paramdef>int <parameter><optional>mode</optional></parameter> </paramdef> </funcprototype> @@ -711,7 +726,7 @@ <funcprototype> <funcdef>string <function>OCINewDescriptor</function></funcdef> <paramdef>int <parameter>connection</parameter></paramdef> - <paramdef>int + <paramdef>int <parameter><optional>type</optional></parameter> </paramdef> </funcprototype> @@ -724,25 +739,26 @@ associati al descrittore, per i BFILE esiste solo il metodo load. Vedere i suggerimenti nel secondo esempio. </para> - <example> - <title>OCINewDescriptor</title> - <programlisting> -<?php - /* This script is designed to be called from a HTML form. - * It expects $user, $password, $table, $where, and $commitsize - * to be passed in from the form. The script then deletes - * the selected rows using the ROWID and commits after each - * set of $commitsize rows. (Use with care, there is no rollback) + <example> + <title>OCINewDescriptor</title> + <programlisting> +<![CDATA[ +<?php + /* Questo codice deve essere richiamato da un form HTML. + * Richiede che $user, $password, $table, $where, e $commitsize + * siano passati dalla form. Il codice quindi cancella + * le tuple selezionate usando ROWID ed esegue un commit ogni + * $commitsize righe. (Usare con attenzione, non si può fare rollback) */ $conn = OCILogon($user, $password); $stmt = OCIParse($conn,"select rowid from $table $where"); $rowid = OCINewDescriptor($conn,OCI_D_ROWID); - OCIDefineByName($stmt,"ROWID",&$rowid); + OCIDefineByName($stmt,"ROWID",&$rowid); OCIExecute($stmt); while ( OCIFetch($stmt) ) { $nrows = OCIRowCount($stmt); $delete = OCIParse($conn,"delete from $table where ROWID = :rid"); - OCIBindByName($delete,":rid",&$rowid,-1,OCI_B_ROWID); + OCIBindByName($delete,":rid",&$rowid,-1,OCI_B_ROWID); OCIExecute($delete); print "$nrows\n"; if ( ($nrows % $commitsize) == 0 ) { @@ -754,29 +770,31 @@ OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> <programlisting> -<?php - /* This script demonstrates file upload to LOB columns - * The formfield used for this example looks like this - * <form action="upload.php3" method="post" enctype="multipart/form-data"> - * <input type="file" name="lob_upload"> +<![CDATA[ +<?php + /* Questo codice dimostra l'upload di file verso campi LOB. + * Il form usato per questo esempio è del tipo seguente: + * <form action="upload.php3" method="post" enctype="multipart/form-data"> + * <input type="file" name="lob_upload"> * ... */ if(!isset($lob_upload) || $lob_upload == 'none'){ ?> -<form action="upload.php3" method="post" enctype="multipart/form-data"> -Upload file: <input type="file" name="lob_upload"><br> -<input type="submit" value="Upload"> - <input type="reset"> -</form> -<?php +<form action="upload.php3" method="post" enctype="multipart/form-data"> +Upload file: <input type="file" name="lob_upload"><br> +<input type="submit" value="Upload"> - <input type="reset"> +</form> +<?php } else { - // $lob_upload contains the temporary filename of the uploaded file + // $lob_upload contiene il nome del file temporaneo $conn = OCILogon($user, $password); $lob = OCINewDescriptor($conn, OCI_D_LOB); $stmt = OCIParse($conn,"insert into $table (id, the_blob) values(my_seq.NEXTVAL, EMPTY_BLOB()) returning the_blob into :the_blob"); - OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB); + OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB); OCIExecute($stmt, OCI_DEFAULT); if($lob->savefile($lob_upload)){ OCICommit($conn); @@ -789,11 +807,44 @@ OCILogoff($conn); } ?> - </programlisting> - </example> +]]> + </programlisting> + </example> + <example> + <title>OCINewDescriptor</title> + <programlisting> +<![CDATA[ +<?php + /* Chiamatai di una stored procedure PL/SQLs che contiene clobs come parametri + * di input (PHP 4 >= 4.0.6). + * La signature della stored prodedure PL/SQL d'esempio è: + * + * PROCEDURE save_data + * Argument Name Type In/Out Default? + * ------------------------------ ----------------------- ------ -------- + * KEY NUMBER(38) IN + * DATA CLOB IN + * + */ + + $conn = OCILogon($user, $password); + $stmt = OCIParse($conn, "begin save_data(:key, :data); end;"); + $clob = OCINewDescriptor($conn, OCI_D_LOB); + OCIBindByName($stmt, ':key', $key); + OCIBindByName($stmt, ':data', $clob, -1, OCI_B_CLOB); + $clob->WriteTemporary($data); + OCIExecute($stmt, OCI_DEFAULT); + OCICommit($conn); + $clob->close(); + $clob->free(); + OCIFreeStatement($stmt); +?> +]]> + </programlisting> + </example> </refsect1> </refentry> - + <refentry id="function.ocirowcount"> <refnamediv> <refname>OCIRowCount</refname> @@ -815,24 +866,28 @@ <example> <title>OCIRowCount</title> <programlisting> -<?php - print "<HTML><PRE>"; +<![CDATA[ +<?php + print "<HTML><PRE>"; $conn = OCILogon("scott","tiger"); $stmt = OCIParse($conn,"create table emp2 as select * from emp"); OCIExecute($stmt); - print OCIRowCount($stmt) . " rows inserted.<BR>"; + print OCIRowCount($stmt) . " rows inserted.<BR>"; OCIFreeStatement($stmt); $stmt = OCIParse($conn,"delete from emp2"); OCIExecute($stmt); - print OCIRowCount($stmt) . " rows deleted.<BR>"; + print OCIRowCount($stmt) . " rows deleted.<BR>"; OCICommit($conn); OCIFreeStatement($stmt); $stmt = OCIParse($conn,"drop table emp2"); OCIExecute($stmt); OCIFreeStatement($stmt); OCILogOff($conn); - print "</PRE></HTML>"; -?> </programlisting></example> + print "</PRE></HTML>"; +?> +]]> + </programlisting> + </example> </para> </refsect1> </refentry> @@ -855,19 +910,20 @@ <para> <function>OCINumCols</function> restituisce il numero di campi contenuti in un'istruzione SQL - </para> - <example> - <title>OCINumCols</title> - <programlisting> -<?php - print "<HTML><PRE>\n"; + </para> + <example> + <title>OCINumCols</title> + <programlisting> +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); while ( OCIFetch($stmt) ) { print "\n"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_value = OCIResult($stmt,$i); print $column_name . ': ' . $column_value . "\n"; @@ -876,9 +932,10 @@ } OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; -?> + print "</PRE>"; + print "</HTML>\n"; + ?> +]]> </programlisting> </example> </refsect1> @@ -1001,7 +1058,8 @@ <example> <title>OCIFetchStatement</title> <programlisting> -<?php +<![CDATA[ +<?php /* OCIFetchStatement example mbritton@verinet.com (990624) */ $conn = OCILogon("scott","tiger"); @@ -1012,36 +1070,37 @@ $nrows = OCIFetchStatement($stmt,$results); if ( $nrows > 0 ) { - print "<TABLE BORDER=\"1\">\n"; - print "<TR>\n"; + print "<TABLE BORDER=\"1\">\n"; + print "<TR>\n"; while ( list( $key, $val ) = each( $results ) ) { - print "<TH>$key</TH>\n"; + print "<TH>$key</TH>\n"; } - print "</TR>\n"; + print "</TR>\n"; - for ( $i = 0; $i < $nrows; $i++ ) { + for ( $i = 0; $i < $nrows; $i++ ) { reset($results); - print "<TR>\n"; + print "<TR>\n"; while ( $column = each($results) ) { $data = $column['value']; - print "<TD>$data[$i]</TD>\n"; + print "<TD>$data[$i]</TD>\n"; } - print "</TR>\n"; + print "</TR>\n"; } - print "</TABLE>\n"; + print "</TABLE>\n"; } else { - echo "No data found<BR>\n"; + echo "No data found<BR>\n"; } -print "$nrows Records Selected<BR>\n"; +print "$nrows Records Selected<BR>\n"; OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> </example> </refsect1> </refentry> - + <refentry id="function.ocicolumnisnull"> <refnamediv> <refname>OCIColumnIsNULL</refname> @@ -1088,33 +1147,35 @@ <example> <title>OCIColumnName</title> <programlisting> -<?php - print "<HTML><PRE>\n"; +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); - print "<TABLE BORDER=\"1\">"; - print "<TR>"; - print "<TH>Name</TH>"; - print "<TH>Type</TH>"; - print "<TH>Length</TH>"; - print "</TR>"; + print "<TABLE BORDER=\"1\">"; + print "<TR>"; + print "<TH>Name</TH>"; + print "<TH>Type</TH>"; + print "<TH>Length</TH>"; + print "</TR>"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_type = OCIColumnType($stmt,$i); $column_size = OCIColumnSize($stmt,$i); - print "<TR>"; - print "<TD>$column_name</TD>"; - print "<TD>$column_type</TD>"; - print "<TD>$column_size</TD>"; - print "</TR>"; + print "<TR>"; + print "<TD>$column_name</TD>"; + print "<TD>$column_type</TD>"; + print "<TD>$column_size</TD>"; + print "</TR>"; } OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; + print "</PRE>"; + print "</HTML>\n"; ?> +]]> </programlisting> </example> </para> @@ -1150,34 +1211,36 @@ <example> <title>OCIColumnSize</title> <programlisting> -<?php - print "<HTML><PRE>\n"; +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); - print "<TABLE BORDER=\"1\">"; - print "<TR>"; - print "<TH>Name</TH>"; - print "<TH>Type</TH>"; - print "<TH>Length</TH>"; - print "</TR>"; + print "<TABLE BORDER=\"1\">"; + print "<TR>"; + print "<TH>Name</TH>"; + print "<TH>Type</TH>"; + print "<TH>Length</TH>"; + print "</TR>"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_type = OCIColumnType($stmt,$i); $column_size = OCIColumnSize($stmt,$i); - print "<TR>"; - print "<TD>$column_name</TD>"; - print "<TD>$column_type</TD>"; - print "<TD>$column_size</TD>"; - print "</TR>"; + print "<TR>"; + print "<TD>$column_name</TD>"; + print "<TD>$column_type</TD>"; + print "<TD>$column_size</TD>"; + print "</TR>"; } - print "</TABLE>"; + print "</TABLE>"; OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; -?> + print "</PRE>"; + print "</HTML>\n"; + ?> +]]> </programlisting> </example> </para> @@ -1207,38 +1270,40 @@ <function>OCIColumnType</function> restituisce il tipo del campo corrispondente alla posizione (1 = primo campo) specificata. - </simpara> + </simpara> <para> <example> <title>OCIColumnType</title> <programlisting> -<?php - print "<HTML><PRE>\n"; +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); - print "<TABLE BORDER=\"1\">"; - print "<TR>"; - print "<TH>Name</TH>"; - print "<TH>Type</TH>"; - print "<TH>Length</TH>"; - print "</TR>"; + print "<TABLE BORDER=\"1\">"; + print "<TR>"; + print "<TH>Name</TH>"; + print "<TH>Type</TH>"; + print "<TH>Length</TH>"; + print "</TR>"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_type = OCIColumnType($stmt,$i); $column_size = OCIColumnSize($stmt,$i); - print "<TR>"; - print "<TD>$column_name</TD>"; - print "<TD>$column_type</TD>"; - print "<TD>$column_size</TD>"; - print "</TR>"; + print "<TR>"; + print "<TD>$column_name</TD>"; + print "<TD>$column_type</TD>"; + print "<TD>$column_size</TD>"; + print "</TR>"; } OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; + print "</PRE>"; + print "</HTML>\n"; ?> +]]> </programlisting> </example> </para> @@ -1268,14 +1333,16 @@ <example> <title>OCIServerVersion</title> <programlisting> -<?php +<![CDATA[ +<?php $conn = OCILogon("scott","tiger"); print "Server Version: " . OCIServerVersion($conn); OCILogOff($conn); ?> +]]> </programlisting> </example> - </para> + </para> </refsect1> </refentry> @@ -1311,19 +1378,21 @@ <example> <title>Code examples</title> <programlisting> -<?php - print "<HTML><PRE>"; +<![CDATA[ +<?php + print "<HTML><PRE>"; $conn = OCILogon("scott","tiger"); $sql = "delete from emp where deptno = 10"; $stmt = OCIParse($conn,$sql); if ( OCIStatementType($stmt) == "DELETE" ) { - die "You are not allowed to delete from this table<BR>"; + die "You are not allowed to delete from this table<BR>"; } OCILogoff($conn); - print "</PRE></HTML>"; + print "</PRE></HTML>"; ?> +]]> </programlisting> </example> </para> @@ -1353,18 +1422,19 @@ <example> <title>Using a REF CURSOR from a stored procedure</title> <programlisting> -<?php +<![CDATA[ +<?php // suppose your stored procedure info.output returns a ref cursor in :data $conn = OCILogon("scott","tiger"); $curs = OCINewCursor($conn); $stmt = OCIParse($conn,"begin info.output(:data); end;"); -ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR); +ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR); ociexecute($stmt); ociexecute($curs); -while (OCIFetchInto($curs,&$data)) { +while (OCIFetchInto($curs,&$data)) { var_dump($data); } @@ -1372,6 +1442,7 @@ OCIFreeCursor($curs); OCILogoff($conn); ?> +]]> </programlisting> </example> </para> @@ -1379,39 +1450,41 @@ <example> <title>Using a REF CURSOR in a select statement</title> <programlisting> -<?php -print "<HTML><BODY>"; +<![CDATA[ +<?php +print "<HTML><BODY>"; $conn = OCILogon("scott","tiger"); $count_cursor = "CURSOR(select count(empno) num_emps from emp " . "where emp.deptno = dept.deptno) as EMPCNT from dept"; $stmt = OCIParse($conn,"select deptno,dname,$count_cursor"); ociexecute($stmt); -print "<TABLE BORDER=\"1\">"; -print "<TR>"; -print "<TH>DEPT NAME</TH>"; -print "<TH>DEPT #</TH>"; -print "<TH># EMPLOYEES</TH>"; -print "</TR>"; +print "<TABLE BORDER=\"1\">"; +print "<TR>"; +print "<TH>DEPT NAME</TH>"; +print "<TH>DEPT #</TH>"; +print "<TH># EMPLOYEES</TH>"; +print "</TR>"; while (OCIFetchInto($stmt,&$data,OCI_ASSOC)) { - print "<TR>"; + print "<TR>"; $dname = $data["DNAME"]; $deptno = $data["DEPTNO"]; - print "<TD>$dname</TD>"; - print "<TD>$deptno</TD>"; + print "<TD>$dname</TD>"; + print "<TD>$deptno</TD>"; ociexecute($data[ "EMPCNT" ]); while (OCIFetchInto($data[ "EMPCNT" ],&$subdata,OCI_ASSOC)) { $num_emps = $subdata["NUM_EMPS"]; - print "<TD>$num_emps</TD>"; + print "<TD>$num_emps</TD>"; } - print "</TR>"; + print "</TR>"; } -print "</TABLE>"; -print "</BODY></HTML>"; +print "</TABLE>"; +print "</BODY></HTML>"; OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> </example> </para> @@ -1531,8 +1604,8 @@ array associativo. In questo array, <parameter>code</parameter> dà il codice d'errora oracle e <parameter>message</parameter> dà la stringa d'errore. - </simpara> - </refsect1> + </simpara> +</refsect1> </refentry> <refentry id="function.ociinternaldebug">
Index: phpdoc/it/functions/oci8.xml diff -u phpdoc/it/functions/oci8.xml:1.18 phpdoc/it/functions/oci8.xml:1.19 --- phpdoc/it/functions/oci8.xml:1.18 Wed Nov 21 16:56:21 2001 +++ phpdoc/it/functions/oci8.xml Thu Nov 22 06:04:04 2001 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> - <!-- EN-Revision: 1.35 Maintainer: cucinato Status: ready --> + <!-- EN-Revision: 1.36 Maintainer: cucinato Status: ready --> <reference id="ref.oci8"> <title>Funzioni Oracle 8</title> <titleabbrev>OCI8</titleabbrev> @@ -97,21 +97,21 @@ </note> <para> <example> - <title>OCI Hints</title> + <title>Trucchi OCI</title> <programlisting role="php"> <![CDATA[ <?php // by sergo@bacup.ru -// Use option: OCI_DEFAULT for execute command to delay execution +// Usare l'opzione OCI_DEFAULT nel comando execute per ritardare l'esicuzione OCIExecute($stmt, OCI_DEFAULT); -// for retrieve data use (after fetch): +// per ricevere i dati utilizzare (dopo il fetch): $result = OCIResult($stmt, $n); if (is_object ($result)) $result = $result->load(); -// For INSERT or UPDATE statement use: +// come comandi INSERT o UPDATE usare: $sql = "insert into table (field1, field2) values (field1 = 'value', field2 = empty_clob()) returning field2 into :field2"; @@ -132,27 +132,29 @@ would from the commands line. <example> <title>Using Stored Procedures</title> - <programlisting role="php"> -<?php + <programlisting role="php"> +<![CDATA[ +<?php // by webmaster@remoterealty.com $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: +// Questo codice richiama la stord procedure sp_newaddress, dove :address_id è +// una variabile in/out e :error_code è una variabile out. +// Quindi si effettua il binding: OCIBindByName ( $sth, ":address_id", $addr_id, 10 ); OCIBindByName ( $sth, ":error_code", $errorcode, 10 ); OCIExecute ( $sth ); -?> +?> +]]> </programlisting> </example> </para> </partintro> - + <refentry id="function.ocidefinebyname"> <refnamediv> <refname>OCIDefineByName</refname> @@ -190,14 +192,15 @@ <example> <title>OCIDefineByName</title> <programlisting> -<?php +<![CDATA[ +<?php /* OCIDefineByPos example thies@thieso.net (980219) */ $conn = OCILogon("scott","tiger"); $stmt = OCIParse($conn,"select empno, ename from emp"); -/* the define MUST be done BEFORE ociexecute! */ +/* il define DEVE essere eseguito PRIMA di ociexecute! */ OCIDefineByName($stmt,"EMPNO",$empno); OCIDefineByName($stmt,"ENAME",$ename); @@ -212,6 +215,7 @@ OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> </example> </refsect1> @@ -259,13 +263,14 @@ (Character-File), OCI_B_CLOB (Character-LOB), OCI_B_BLOB (Binary-LOB) e OCI_B_ROWID (ROWID). </para> - <example> - <title>OCIDefineByName</title> - <programlisting> -<?php + <example> + <title>OCIDefineByName</title> + <programlisting> +<![CDATA[ +<?php /* OCIBindByPos example thies@thieso.net (980221) - inserts 3 records into emp, and uses the ROWID for updating the - records just after the insert. + inserisce 3 tuple in emp, e usa ROWID per aggiornare le + tuple subito dopo l'inserimento. */ $conn = OCILogon("scott","tiger"); @@ -312,8 +317,9 @@ OCILogoff($conn); ?> - </programlisting> - </example> +]]> + </programlisting> + </example> <warning> <para> It is a bad idea to use magic quotes and @@ -363,8 +369,9 @@ <example> <title>OCILogon</title> <programlisting> -<?php -print "<HTML><PRE>"; +<![CDATA[ +<?php +print "<HTML><PRE>"; $db = ""; $c1 = ocilogon("scott","tiger",$db); @@ -410,7 +417,7 @@ ociexecute($stmt,OCI_DEFAULT); echo $conn."----selecting\n\n"; while (ocifetch($stmt)) - echo $conn." <".ociresult($stmt,"TEST").">\n\n"; + echo $conn." <".ociresult($stmt,"TEST").">\n\n"; echo $conn."----done\n\n"; } @@ -441,8 +448,12 @@ drop_table($c1); -print "</PRE></HTML>"; -?></programlisting></example></para> +print "</PRE></HTML>"; +?> +]]> + </programlisting> + </example> + </para> <simpara> Vedere anche <function>OCIPLogon</function> e <function>OCINLogon</function>.</simpara> @@ -462,9 +473,9 @@ <funcdef>int <function>OCIPLogon</function></funcdef> <paramdef>string <parameter>username</parameter></paramdef> <paramdef>string <parameter>password</parameter></paramdef> - <paramdef>string + <paramdef>string <parameter><optional>db</optional></parameter> - </paramdef> + </paramdef> </funcprototype> </funcsynopsis> <para> @@ -496,7 +507,7 @@ <funcdef>int <function>OCINLogon</function></funcdef> <paramdef>string <parameter>username</parameter></paramdef> <paramdef>string <parameter>password</parameter></paramdef> - <paramdef>string + <paramdef>string <parameter><optional>db</optional></parameter> </paramdef> </funcprototype> @@ -524,8 +535,9 @@ <example> <title>OCINLogon</title> <programlisting> -<?php -print "<HTML><PRE>"; +<![CDATA[ +<?php +print "<HTML><PRE>"; $db = ""; $c1 = ocilogon("scott","tiger",$db); @@ -572,7 +584,7 @@ ociexecute($stmt,OCI_DEFAULT); echo $conn."----selecting\n\n"; while (ocifetch($stmt)) - echo $conn." <".ociresult($stmt,"TEST").">\n\n"; + echo $conn." <".ociresult($stmt,"TEST").">\n\n"; echo $conn."----done\n\n"; } @@ -602,8 +614,11 @@ drop_table($c1); -print "</PRE></HTML>"; -?></programlisting></example> +print "</PRE></HTML>"; +?> +]]> + </programlisting> + </example> </para> <simpara> Vedere anche <function>OCILogon</function> e @@ -642,7 +657,7 @@ <funcprototype> <funcdef>int <function>OCIExecute</function></funcdef> <paramdef>int <parameter>statement</parameter></paramdef> - <paramdef>int + <paramdef>int <parameter><optional>mode</optional></parameter> </paramdef> </funcprototype> @@ -711,7 +726,7 @@ <funcprototype> <funcdef>string <function>OCINewDescriptor</function></funcdef> <paramdef>int <parameter>connection</parameter></paramdef> - <paramdef>int + <paramdef>int <parameter><optional>type</optional></parameter> </paramdef> </funcprototype> @@ -724,25 +739,26 @@ associati al descrittore, per i BFILE esiste solo il metodo load. Vedere i suggerimenti nel secondo esempio. </para> - <example> - <title>OCINewDescriptor</title> - <programlisting> -<?php - /* This script is designed to be called from a HTML form. - * It expects $user, $password, $table, $where, and $commitsize - * to be passed in from the form. The script then deletes - * the selected rows using the ROWID and commits after each - * set of $commitsize rows. (Use with care, there is no rollback) + <example> + <title>OCINewDescriptor</title> + <programlisting> +<![CDATA[ +<?php + /* Questo codice deve essere richiamato da un form HTML. + * Richiede che $user, $password, $table, $where, e $commitsize + * siano passati dalla form. Il codice quindi cancella + * le tuple selezionate usando ROWID ed esegue un commit ogni + * $commitsize righe. (Usare con attenzione, non si può fare rollback) */ $conn = OCILogon($user, $password); $stmt = OCIParse($conn,"select rowid from $table $where"); $rowid = OCINewDescriptor($conn,OCI_D_ROWID); - OCIDefineByName($stmt,"ROWID",&$rowid); + OCIDefineByName($stmt,"ROWID",&$rowid); OCIExecute($stmt); while ( OCIFetch($stmt) ) { $nrows = OCIRowCount($stmt); $delete = OCIParse($conn,"delete from $table where ROWID = :rid"); - OCIBindByName($delete,":rid",&$rowid,-1,OCI_B_ROWID); + OCIBindByName($delete,":rid",&$rowid,-1,OCI_B_ROWID); OCIExecute($delete); print "$nrows\n"; if ( ($nrows % $commitsize) == 0 ) { @@ -754,29 +770,31 @@ OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> <programlisting> -<?php - /* This script demonstrates file upload to LOB columns - * The formfield used for this example looks like this - * <form action="upload.php3" method="post" enctype="multipart/form-data"> - * <input type="file" name="lob_upload"> +<![CDATA[ +<?php + /* Questo codice dimostra l'upload di file verso campi LOB. + * Il form usato per questo esempio è del tipo seguente: + * <form action="upload.php3" method="post" enctype="multipart/form-data"> + * <input type="file" name="lob_upload"> * ... */ if(!isset($lob_upload) || $lob_upload == 'none'){ ?> -<form action="upload.php3" method="post" enctype="multipart/form-data"> -Upload file: <input type="file" name="lob_upload"><br> -<input type="submit" value="Upload"> - <input type="reset"> -</form> -<?php +<form action="upload.php3" method="post" enctype="multipart/form-data"> +Upload file: <input type="file" name="lob_upload"><br> +<input type="submit" value="Upload"> - <input type="reset"> +</form> +<?php } else { - // $lob_upload contains the temporary filename of the uploaded file + // $lob_upload contiene il nome del file temporaneo $conn = OCILogon($user, $password); $lob = OCINewDescriptor($conn, OCI_D_LOB); $stmt = OCIParse($conn,"insert into $table (id, the_blob) values(my_seq.NEXTVAL, EMPTY_BLOB()) returning the_blob into :the_blob"); - OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB); + OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLOB); OCIExecute($stmt, OCI_DEFAULT); if($lob->savefile($lob_upload)){ OCICommit($conn); @@ -789,11 +807,44 @@ OCILogoff($conn); } ?> - </programlisting> - </example> +]]> + </programlisting> + </example> + <example> + <title>OCINewDescriptor</title> + <programlisting> +<![CDATA[ +<?php + /* Chiamatai di una stored procedure PL/SQLs che contiene clobs come parametri + * di input (PHP 4 >= 4.0.6). + * La signature della stored prodedure PL/SQL d'esempio è: + * + * PROCEDURE save_data + * Argument Name Type In/Out Default? + * ------------------------------ ----------------------- ------ -------- + * KEY NUMBER(38) IN + * DATA CLOB IN + * + */ + + $conn = OCILogon($user, $password); + $stmt = OCIParse($conn, "begin save_data(:key, :data); end;"); + $clob = OCINewDescriptor($conn, OCI_D_LOB); + OCIBindByName($stmt, ':key', $key); + OCIBindByName($stmt, ':data', $clob, -1, OCI_B_CLOB); + $clob->WriteTemporary($data); + OCIExecute($stmt, OCI_DEFAULT); + OCICommit($conn); + $clob->close(); + $clob->free(); + OCIFreeStatement($stmt); +?> +]]> + </programlisting> + </example> </refsect1> </refentry> - + <refentry id="function.ocirowcount"> <refnamediv> <refname>OCIRowCount</refname> @@ -815,24 +866,28 @@ <example> <title>OCIRowCount</title> <programlisting> -<?php - print "<HTML><PRE>"; +<![CDATA[ +<?php + print "<HTML><PRE>"; $conn = OCILogon("scott","tiger"); $stmt = OCIParse($conn,"create table emp2 as select * from emp"); OCIExecute($stmt); - print OCIRowCount($stmt) . " rows inserted.<BR>"; + print OCIRowCount($stmt) . " rows inserted.<BR>"; OCIFreeStatement($stmt); $stmt = OCIParse($conn,"delete from emp2"); OCIExecute($stmt); - print OCIRowCount($stmt) . " rows deleted.<BR>"; + print OCIRowCount($stmt) . " rows deleted.<BR>"; OCICommit($conn); OCIFreeStatement($stmt); $stmt = OCIParse($conn,"drop table emp2"); OCIExecute($stmt); OCIFreeStatement($stmt); OCILogOff($conn); - print "</PRE></HTML>"; -?> </programlisting></example> + print "</PRE></HTML>"; +?> +]]> + </programlisting> + </example> </para> </refsect1> </refentry> @@ -855,19 +910,20 @@ <para> <function>OCINumCols</function> restituisce il numero di campi contenuti in un'istruzione SQL - </para> - <example> - <title>OCINumCols</title> - <programlisting> -<?php - print "<HTML><PRE>\n"; + </para> + <example> + <title>OCINumCols</title> + <programlisting> +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); while ( OCIFetch($stmt) ) { print "\n"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_value = OCIResult($stmt,$i); print $column_name . ': ' . $column_value . "\n"; @@ -876,9 +932,10 @@ } OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; -?> + print "</PRE>"; + print "</HTML>\n"; + ?> +]]> </programlisting> </example> </refsect1> @@ -1001,7 +1058,8 @@ <example> <title>OCIFetchStatement</title> <programlisting> -<?php +<![CDATA[ +<?php /* OCIFetchStatement example mbritton@verinet.com (990624) */ $conn = OCILogon("scott","tiger"); @@ -1012,36 +1070,37 @@ $nrows = OCIFetchStatement($stmt,$results); if ( $nrows > 0 ) { - print "<TABLE BORDER=\"1\">\n"; - print "<TR>\n"; + print "<TABLE BORDER=\"1\">\n"; + print "<TR>\n"; while ( list( $key, $val ) = each( $results ) ) { - print "<TH>$key</TH>\n"; + print "<TH>$key</TH>\n"; } - print "</TR>\n"; + print "</TR>\n"; - for ( $i = 0; $i < $nrows; $i++ ) { + for ( $i = 0; $i < $nrows; $i++ ) { reset($results); - print "<TR>\n"; + print "<TR>\n"; while ( $column = each($results) ) { $data = $column['value']; - print "<TD>$data[$i]</TD>\n"; + print "<TD>$data[$i]</TD>\n"; } - print "</TR>\n"; + print "</TR>\n"; } - print "</TABLE>\n"; + print "</TABLE>\n"; } else { - echo "No data found<BR>\n"; + echo "No data found<BR>\n"; } -print "$nrows Records Selected<BR>\n"; +print "$nrows Records Selected<BR>\n"; OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> </example> </refsect1> </refentry> - + <refentry id="function.ocicolumnisnull"> <refnamediv> <refname>OCIColumnIsNULL</refname> @@ -1088,33 +1147,35 @@ <example> <title>OCIColumnName</title> <programlisting> -<?php - print "<HTML><PRE>\n"; +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); - print "<TABLE BORDER=\"1\">"; - print "<TR>"; - print "<TH>Name</TH>"; - print "<TH>Type</TH>"; - print "<TH>Length</TH>"; - print "</TR>"; + print "<TABLE BORDER=\"1\">"; + print "<TR>"; + print "<TH>Name</TH>"; + print "<TH>Type</TH>"; + print "<TH>Length</TH>"; + print "</TR>"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_type = OCIColumnType($stmt,$i); $column_size = OCIColumnSize($stmt,$i); - print "<TR>"; - print "<TD>$column_name</TD>"; - print "<TD>$column_type</TD>"; - print "<TD>$column_size</TD>"; - print "</TR>"; + print "<TR>"; + print "<TD>$column_name</TD>"; + print "<TD>$column_type</TD>"; + print "<TD>$column_size</TD>"; + print "</TR>"; } OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; + print "</PRE>"; + print "</HTML>\n"; ?> +]]> </programlisting> </example> </para> @@ -1150,34 +1211,36 @@ <example> <title>OCIColumnSize</title> <programlisting> -<?php - print "<HTML><PRE>\n"; +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); - print "<TABLE BORDER=\"1\">"; - print "<TR>"; - print "<TH>Name</TH>"; - print "<TH>Type</TH>"; - print "<TH>Length</TH>"; - print "</TR>"; + print "<TABLE BORDER=\"1\">"; + print "<TR>"; + print "<TH>Name</TH>"; + print "<TH>Type</TH>"; + print "<TH>Length</TH>"; + print "</TR>"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_type = OCIColumnType($stmt,$i); $column_size = OCIColumnSize($stmt,$i); - print "<TR>"; - print "<TD>$column_name</TD>"; - print "<TD>$column_type</TD>"; - print "<TD>$column_size</TD>"; - print "</TR>"; + print "<TR>"; + print "<TD>$column_name</TD>"; + print "<TD>$column_type</TD>"; + print "<TD>$column_size</TD>"; + print "</TR>"; } - print "</TABLE>"; + print "</TABLE>"; OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; -?> + print "</PRE>"; + print "</HTML>\n"; + ?> +]]> </programlisting> </example> </para> @@ -1207,38 +1270,40 @@ <function>OCIColumnType</function> restituisce il tipo del campo corrispondente alla posizione (1 = primo campo) specificata. - </simpara> + </simpara> <para> <example> <title>OCIColumnType</title> <programlisting> -<?php - print "<HTML><PRE>\n"; +<![CDATA[ +<?php + print "<HTML><PRE>\n"; $conn = OCILogon("scott", "tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); - print "<TABLE BORDER=\"1\">"; - print "<TR>"; - print "<TH>Name</TH>"; - print "<TH>Type</TH>"; - print "<TH>Length</TH>"; - print "</TR>"; + print "<TABLE BORDER=\"1\">"; + print "<TR>"; + print "<TH>Name</TH>"; + print "<TH>Type</TH>"; + print "<TH>Length</TH>"; + print "</TR>"; $ncols = OCINumCols($stmt); - for ( $i = 1; $i <= $ncols; $i++ ) { + for ( $i = 1; $i <= $ncols; $i++ ) { $column_name = OCIColumnName($stmt,$i); $column_type = OCIColumnType($stmt,$i); $column_size = OCIColumnSize($stmt,$i); - print "<TR>"; - print "<TD>$column_name</TD>"; - print "<TD>$column_type</TD>"; - print "<TD>$column_size</TD>"; - print "</TR>"; + print "<TR>"; + print "<TD>$column_name</TD>"; + print "<TD>$column_type</TD>"; + print "<TD>$column_size</TD>"; + print "</TR>"; } OCIFreeStatement($stmt); OCILogoff($conn); - print "</PRE>"; - print "</HTML>\n"; + print "</PRE>"; + print "</HTML>\n"; ?> +]]> </programlisting> </example> </para> @@ -1268,14 +1333,16 @@ <example> <title>OCIServerVersion</title> <programlisting> -<?php +<![CDATA[ +<?php $conn = OCILogon("scott","tiger"); print "Server Version: " . OCIServerVersion($conn); OCILogOff($conn); ?> +]]> </programlisting> </example> - </para> + </para> </refsect1> </refentry> @@ -1311,19 +1378,21 @@ <example> <title>Code examples</title> <programlisting> -<?php - print "<HTML><PRE>"; +<![CDATA[ +<?php + print "<HTML><PRE>"; $conn = OCILogon("scott","tiger"); $sql = "delete from emp where deptno = 10"; $stmt = OCIParse($conn,$sql); if ( OCIStatementType($stmt) == "DELETE" ) { - die "You are not allowed to delete from this table<BR>"; + die "You are not allowed to delete from this table<BR>"; } OCILogoff($conn); - print "</PRE></HTML>"; + print "</PRE></HTML>"; ?> +]]> </programlisting> </example> </para> @@ -1353,18 +1422,19 @@ <example> <title>Using a REF CURSOR from a stored procedure</title> <programlisting> -<?php +<![CDATA[ +<?php // suppose your stored procedure info.output returns a ref cursor in :data $conn = OCILogon("scott","tiger"); $curs = OCINewCursor($conn); $stmt = OCIParse($conn,"begin info.output(:data); end;"); -ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR); +ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR); ociexecute($stmt); ociexecute($curs); -while (OCIFetchInto($curs,&$data)) { +while (OCIFetchInto($curs,&$data)) { var_dump($data); } @@ -1372,6 +1442,7 @@ OCIFreeCursor($curs); OCILogoff($conn); ?> +]]> </programlisting> </example> </para> @@ -1379,39 +1450,41 @@ <example> <title>Using a REF CURSOR in a select statement</title> <programlisting> -<?php -print "<HTML><BODY>"; +<![CDATA[ +<?php +print "<HTML><BODY>"; $conn = OCILogon("scott","tiger"); $count_cursor = "CURSOR(select count(empno) num_emps from emp " . "where emp.deptno = dept.deptno) as EMPCNT from dept"; $stmt = OCIParse($conn,"select deptno,dname,$count_cursor"); ociexecute($stmt); -print "<TABLE BORDER=\"1\">"; -print "<TR>"; -print "<TH>DEPT NAME</TH>"; -print "<TH>DEPT #</TH>"; -print "<TH># EMPLOYEES</TH>"; -print "</TR>"; +print "<TABLE BORDER=\"1\">"; +print "<TR>"; +print "<TH>DEPT NAME</TH>"; +print "<TH>DEPT #</TH>"; +print "<TH># EMPLOYEES</TH>"; +print "</TR>"; while (OCIFetchInto($stmt,&$data,OCI_ASSOC)) { - print "<TR>"; + print "<TR>"; $dname = $data["DNAME"]; $deptno = $data["DEPTNO"]; - print "<TD>$dname</TD>"; - print "<TD>$deptno</TD>"; + print "<TD>$dname</TD>"; + print "<TD>$deptno</TD>"; ociexecute($data[ "EMPCNT" ]); while (OCIFetchInto($data[ "EMPCNT" ],&$subdata,OCI_ASSOC)) { $num_emps = $subdata["NUM_EMPS"]; - print "<TD>$num_emps</TD>"; + print "<TD>$num_emps</TD>"; } - print "</TR>"; + print "</TR>"; } -print "</TABLE>"; -print "</BODY></HTML>"; +print "</TABLE>"; +print "</BODY></HTML>"; OCIFreeStatement($stmt); OCILogoff($conn); ?> +]]> </programlisting> </example> </para> @@ -1531,8 +1604,8 @@ array associativo. In questo array, <parameter>code</parameter> dà il codice d'errora oracle e <parameter>message</parameter> dà la stringa d'errore. - </simpara> - </refsect1> + </simpara> +</refsect1> </refentry> <refentry id="function.ociinternaldebug">