Hello,

I'm using some Oracle types that belong to a certain schema. I've code
some classes that implement java.sql.SQLData to manage the conversion
between the java and oracle types.

The SQL type the classes report is "schema_name.object_name".

The application connects to the database by using an user different
from the one that owns the tables, and there are synonyms for all the
interested objects (tables, views, etc).

The problem is that if I remove the schema name from the sql type name
in the java class the object type is not found when passing an object
to or from a stored procedure, even though a synonym is created for
the object.

Any idea?

Thanks