Synonym Problem with Blobs

I have a table with a blob column. I granted another user with full
privileges against that table and defined a synonym for that user for
that table. If I run a perl DBI when I'm the 2nd user and use the
synonym to specify that table and try query against the blob I get a

DBD::Oracle::st execute failed: ORA-04043: object blobtest does not
exist (DBD SUCCESS: OCIDescribeAny/LOB refetch) at yankblobl.pl line 35.

execute: ORA-04043: object blobtest does not exist (DBD SUCCESS:
OCIDescribeAny/LOB refetch) at yankblobl.pl line 35.

When I fully specify the table it works. However, due to various
constraints fully specifying the tables will not work for me.  The query

works fine in SQLPLUS using PL/SQL. Any ideas?

Any ideas?

Thanks.

--
Jeff Thompson                   |       Phone: (515)956-9277
Senior Database Administrator   |       email: jeff.thompson@e-markets.com
"vivendo immo moriendo et damnando fit theologus, non intelligendo legendo aut
speculando". (Luther)

• Synonym Problem with Blobs by Jeff Thompson