Problem with insert a BLOB into Oracle

[John Whitnack]

Hi,

I am having a problem with saving a Binary file to BLOB column in Oracle. I get a weird error message telling me that the table does not exists even though I can see it using SQLplus. He is a sample of the code I am using.

..
..
..
$query = "INSERT INTO file_table
VALUES (?,?)";

$sth = $handle->prepare($query);
$sth->bind_param(1,$entity_id);
$sth->bind_param(2,$file,{ora_type => ORA_BLOB});

$results = $sth->execute();
..
..
..

The exact error message I recieve is:

DBD::Oracle::st execute failed: ORA-04043: object file_table does not exist (DBD SUCCESS: OCIDescribeAny(view)/LOB refetch) at LoadFile.pl line 180.

Does anyone know what could be causing it not to see the table?

--
John Whitnack
Gilbert Laustsen Jung
[EMAIL PROTECTED]
(403)-266-9517