(Fwd)

From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 10:16:55 +0100
To: dbi-users@perl.org

----- Forwarded message from Mourad.Ait-Abdelkader@serono.com -----

Delivered-To: tim.bunce@pobox.com
X-Pobox-Antispam: Bad HELO hostname returned DENY: no MX or A records found for ch8mm001.serono.com
X-SPF-Guess: pass (seems reasonable for mourad.ait-abdelkader@serono.com to mail through 193.134.210.51)
Subject:
To: Tim.Bunce@pobox.com
From: Mourad.Ait-Abdelkader@serono.com
Date: Mon, 17 May 2004 10:08:19 +0200

Hello,

I have a table with a blob column. I granted another user with full
privileges against that table and defined a public synonym for that table.
If I run a perl DBI when I'm the second user and use the synonym to specify
that table and try insert or update against the blob I get an error :

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

When I fully specify the table it works.

Any ideas?

DBD Oracle Version = '1.06'

Thanks.

********************************************************************************************
S - This message contains confidential information and is intended only for the individual
named. If you are not the named addressee, you should not disseminate, distribute or copy
this e-mail. Please notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
e-mail transmission cannot be guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain malware. The
presence of this disclaimer is not a proof that it was originated at Serono International S.A.
or one of its affiliates. Serono International S.A and its affiliates therefore do not accept
liability for any errors or omissions in the content of this message, which arise as a result
of e-mail transmission. If verification is required, please request a hard-copy version.
Serono International SA, 15bis Chemin Des Mines, Geneva, Switzerland, www.serono.com.
*********************************************************************************************

----- End forwarded message -----