attention Perl master

A co-worker wrote a perl script which inserts information into a table with a LOB value
When the script is run inserting into a table which is in the user A's schema that runs the perl script it works fine. When the script is run inserting into a table which is in user B's schema they gets:

 DBD::Oracle::st execute failed: ORA-04043: object
> im_queue does not exist
> (DBD SUCCESS: OCIDescribeAny/LOB refetch)

NOTE: the synonym for B.table is there and user A can see the table

            User A is able to insert, delete, update, etc into user's B table without a problem in sqlplus or other methods

I do not want to have to hard code B.table into this script as the schema name can vary. Is there a way to solve this? Is there another permission I need
to grant that is different for Perl? Received on Thu Dec 14 2000 - 14:02:54 CST