PHP 8.0.26 Released!


(PHP 8.2, PECL OCI8 >= 3.2)

oci_set_prefetch_lobSets the amount of data prefetched for each CLOB or BLOB.


oci_set_prefetch_lob(resource $statement, int $prefetch_lob_size): bool

Sets the internal buffer size used to fetch each CLOB or BLOB value when the implementation gets the internal Oracle LOB locator from the database after a successful query call to oci_execute() and for each subsequent internal fetch request to the database. Increasing this value can improve the performance of fetching smaller LOBs by reducing round-trips between PHP and the database. Memory usage will change.

The value affects LOBs returned as OCILob instances and also those returned using OCI_RETURN_LOBS.

Call oci_set_prefetch_lob() before calling oci_execute(). If it is not called, the value of oci8.prefetch_lob_size is used.

The LOB prefetch value should only be set with Oracle Database 12.2 or later.

Liste de paramètres


Un identifiant de requête OCI8 créé par la fonction oci_parse() et exécuté par la fonction oci_execute(), ou un identifiant de requête REF CURSOR.


The number of bytes of each LOB to be prefetched, >= 0

Valeurs de retour

Cette fonction retourne true en cas de succès ou false si une erreur survient.


Exemple #1 Changing the LOB prefetch value for a query



$stid oci_parse($conn'SELECT myclob FROM mytable');
oci_set_prefetch_lob($stid100000);  // Set before calling oci_execute()

"<table border='1'>\n";
while (
$row oci_fetch_array($stidOCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS)) {
    foreach (
$row as $item) {
"    <td>".($item !== null htmlentities($itemENT_QUOTES) : "&nbsp;")."</td>\n";



Voir aussi

add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top