Subject: | problem with update/insert into LOB when object is PUBLIC SYNONYM |
When insering or updating in a LOB (CLOB or BLOB) column of an object that is a PUBLIC SYNONYM you get an error that the table cannot be found.
This happens because the test to see wether you are dealing with a synonym is done by querying the synonyms available to the user, not taking into account the PUBLIC synonyms.