Oracle error to insert image into BLOB

[Anon]

Hi,
I am trying to insert an image using the following code.

$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);

I am getting a ORA-01465: invalid hex number error. Does anybody have any clue?

(my $filename = /u1/apache/docs/image.gif)

[Anon]

I fixed the error...thanks to ocinewdescriptor. Basically you insert an empty_blob first, then you fill in your database with the file afterward. Hopes this saves someone a lot of time.

function upload_image($new_image_file, $new_stored_err_id)
{
include('inc_TEST_db.php'); //Test database
$filename = "/testing/".$new_image_file['name'][0];
$filetype = $new_image_file['type'][0];
$filesize = $new_image_file['size'][0];

$sql  = "insert into mdi_err_image (err_id, err_image, filename, filetype, filesize) ";
$sql .= "values ($new_stored_err_id, EMPTY_BLOB(), '$filename', '$filetype', '$filesize') ";
$sql .= "returning err_image into :blob";

$blob = OCINewDescriptor($conn, OCI_D_LOB); 

$stmt = ociParse($conn,$sql);
OCIBindByName($stmt, ':blob', $blob, -1, OCI_B_BLOB); 
OCIExecute($stmt, OCI_DEFAULT);

//Data saved to Database
if ($blob->savefile($filename)) 
{ 
OCICommit($conn); 
} else { 
echo ("Problems uploading Image"); 
OCIFreeDesc($blob); 
OCIFreeStatement($stmt); 
exit; 
} 
OCIFreeDesc($blob); 
OCIFreeStatement($stmt); 

}