OCI-Lob::import
Reading a OCI-Lob by using the load() function will return only 2k chars, so you miss part of its contents.
For example:
<?php
$sql = "BEGIN :res := getACLOB(id).getclobval(); END;";
$stmt = oci_parse($conn, $sql);
$resVal = OCINewDescriptor($conn, OCI_D_LOB);
oci_bind_by_name($stmt, ":res", $resVal, -1, OCI_B_CLOB);
oci_execute($stmt);
$foo = $resVal->load();
// $foo will contain only 2k chars
// the following will neither work
$foo = $resVal->read( $resVal->size() );
// $foo will contain only 2k chars
?>
Use this instead:
<?php
$sql = "BEGIN :res := getACLOB(id).getclobval(); END;";
$stmt = oci_parse($conn, $sql);
$resVal = OCINewDescriptor($conn, OCI_D_LOB);
oci_bind_by_name($stmt, ":res", $resVal, -1, OCI_B_CLOB);
oci_execute($stmt);
$foo = "";
while(!$resVal->eof()){
$foo .= $resVal->read(2000);
}
// $foo will contain full contents of the CLOB
?>
OCI-Lob::load
(PHP 5, PECL OCI8 >= 1.1.0)
OCI-Lob::load — Devuelve el contenido de un objeto grande
Descripción
string OCI-Lob::load
( void
)
Devuelve el contenido de un objeto grande. Ya que la ejecución de un script finaliza cuando se alcanza el valor de memory_limit, asegúrese de que el LOB no execede dicho límite. En la mayoría de los casos se recomienda usar en su lugar OCI-Lob::read.
Valores devueltos
Devuelve el contenido del objeto, o FALSE en caso de error.
add a note
User Contributed Notes
OCI-Lob::load - [3 notes]
pablo dot casado at layers dot com ¶
3 years ago
FaLL3N at mail dot ru ¶
6 years ago
Ps. To prevent IE errors like 'File not found!' after downloading file from db I recommend to add next two lines into header:
header('Cache-Control: max-age=0');
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
With this, IE will open any file normally :)
FaLL3N at mail dot ru ¶
6 years ago
I'll give you example how to download a file from db without storing it on server's FS:
It works like this - point yor browser to index.php?name=file.ext
Just make sure that file "file.ext" exists in your db!
Code:
<?php
$dbConnection=ocilogon('user','pass','data.world'); //login stuff
$sql_SelectBlob='select document_body,filename from tdocuments where id=1'; //selecting a blob field named 'document_body' with id = 1
$statement=OCIParse($dbConnection,$sql_SelectBlob);
OCIExecute($statement) or die($sql_SelectBlob.'<hr>');
if(OCIFetch($statement)) //if file exists
{
$a=OCIResult($statement,"DOCUMENT_BODY");
}
header('Content-type: application/octet-stream;');
header('Content-disposition: attachment;filename='.$_GET['name']);
print $a->load();
//browser promts to save or open the file
?>
Have fun!