Oracle retrieving jpg from blob into memory
| From: | Paul Fernandez | Date: | Thu, 03 Aug 2000 15:55:52 +0000 |
| Subject: | Oracle retrieving jpg from blob into memory | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1758@lists.php.net to get a copy of this message | ||
Hello,
I have this piece of code that pulls in and displays a blob in text
format:
$stmt = ociparse($connection,"select * from table");
ociexecute ($stmt,OCI_DEFAULT);
while (ocifetchinto($stmt,&$arr,OCI_RETURN_LOBS))
{
var_dump($arr);
}
What I've been trying to do is pull out a jpg that exists as a blob in a
table, and properly display it in a web page. I've seen and used
scripts that would take a blob, write it to a file (picture.jpg) and
then refer to it in the html script. But I've seen perl scripts pull in
a blob to memory and output it to the web page WITHOUT writing to the
file system.
Thanks in advance
--
Paul Fernandez
Webmaster
Structural GenomiX, Inc.