RE: (Fwd)

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 08:13:04 -0600
To: "Tim Bunce" <Tim.Bunce@pobox.com>, <dbi-users@perl.org>

Are you sure the synonym worked?

-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.

-----Original Message-----
From: Tim Bunce [mailto:Tim.Bunce@pobox.com]
Sent: Monday, May 17, 2004 3:17 AM
To: dbi-users@perl.org
Cc: Mourad.Ait-Abdelkader@serono.com
Subject: (Fwd)

----- 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 -----

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.