----- Forwarded message from [EMAIL PROTECTED] ----- Delivered-To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] to mail through 193.134.210.51) Subject: To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] 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 -----
