Last 5.3 release ever available: PHP 5.3.29 - 5.3 now EOL

oci_field_size

(PHP 5, PECL OCI8 >= 1.1.0)

oci_field_sizeReturns field's size

Descrição

int oci_field_size ( resource $statement , mixed $field )

Returns the size of a field.

Parâmetros

statement

A valid OCI statement identifier.

field

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

Valor Retornado

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

Exemplos

Exemplo #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);
?>

Notas

Nota:

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.

Veja Também

add a note add a note

User Contributed Notes 1 note

up
0
rudi at darx dot com
14 years ago
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.
To Top