PHP Doku:: Returns field s size - function.oci-field-size.html

Verlauf / Chronik / History: (1) anzeigen

Sie sind hier:
Doku-StartseitePHP-HandbuchFunktionsreferenzDatenbankerweiterungenAnbieterspezifische DatenbankerweiterungenOracle OCI8OCI8 Funktionenoci_field_size

Ein Service von Reinhard Neidl - Webprogrammierung.

OCI8 Funktionen

<<oci_field_scale

oci_field_type_raw>>

oci_field_size

(PHP 5, PECL OCI8 >= 1.1.0)

oci_field_sizeReturns field's size

Beschreibung

int oci_field_size ( resource $statement , mixed $field )

Returns the size of a field.

Parameter-Liste

statement

A valid OCI statement identifier.

field

Can be the field's index (1-based) or name.

Rückgabewerte

Returns the size of a field in bytes, or FALSE on errors.

Beispiele

Beispiel #1 oci_field_size() example

<?php
$conn 
oci_connect("scott""tiger");
$stmt oci_parse($conn"SELECT * FROM emp");
oci_execute($stmt);

echo 
"<table border=\"1\">";
echo 
"<tr>";
echo 
"<th>Name</th>";
echo 
"<th>Type</th>";
echo 
"<th>Length</th>";
echo 
"</tr>";

$ncols oci_num_fields($stmt);

for (
$i 1$i <= $ncols$i++) {
    
$column_name  oci_field_name($stmt$i);
    
$column_type  oci_field_type($stmt$i);
    
$column_size  oci_field_size($stmt$i);
    echo 
"<tr>";
    echo 
"<td>$column_name</td>";
    echo 
"<td>$column_type</td>";
    echo 
"<td>$column_size</td>";
    echo 
"</tr>";
}

echo 
"</table>";

oci_free_statement($stmt);
oci_close($conn);
?>

Anmerkungen

Hinweis:

In PHP versions before 5.0.0 you must use ocicolumnsize() instead. This name still can be used, it was left as alias of oci_field_size() for downwards compatability. This, however, is deprecated and not recommended.

Siehe auch


2 BenutzerBeiträge:
- Beiträge aktualisieren...
taq at terra dot com dot br
30.04.2002 17:19
Using OCIColumnPrecision() I got the correct field size ( not the Oracle 22 fixed value ). Don't know if its the correct behaviour, but it works. :)
rudi at darx dot com
16.07.2000 19:19
Just a note regarding the size of Oracle  NUMBERS will always return 22 as their "size".

This seems to be an Oracle feature. The rest of the documentation is in bug5156.



PHP Powered Diese Seite bei php.net
The PHP manual text and comments are covered by the Creative Commons Attribution 3.0 License © the PHP Documentation Group - Impressum - mail("TO:Reinhard Neidl",...)