Oracle image

[Anon]

Hi,
I know that BLOBs can go into an Oracle database, but I'm having a lot of trouble trying to stick it in. Here's my code so far...

$filename = "/u1/apache/docs/image.gif";

$binary_file = addslashes(fread(fopen($filename, "r"), filesize($filename)));

$sql_stmt .= "INSERT INTO mdi_err_image (err_id, err_image) VALUES ($err_id, '$binary_file')";

$stmt = ociParse($conn, $sql_stmt);
ociExecute($stmt);

ORA-00972: Identifier too long (when I pass in a larger gif file)
ORA-01465: invalid hex number error. (when I pass in a really small gif file)

Does anybody have any clue?

[bastien]

why even do it?

best method is to store the string of the path and filename into the Db and store the image in folder...

you get no awkward coding, no database bloat, no db performance issues

then when displaying in html page it is really easy

after database call
$ip = $row["path_to_img"];

echo "<img src = $pic>"

hth

bastien