We have two users for our database X1 and X2.
X1 user owns the objects and has created
public synonyms for the same. This
user has granted permissions for X2 user
only to execute the stored procedures. The
stored procedures return a reference to
the cursor (which will be received as a
ResultSet in Java). While retrieving a
CLOB value from the ResultSet the following
error is encountered :

java.sql.SQLException: ORA-00942: table or view does not exist

The above error occurs only with a 8i database. With all
the settings remaining the same, the error is not noticed
while executing against a 9i database. Does 8i require
any permission to be given to users for using CLOBs and other
LOB datatypes?

Note : X2 is an application user and has to do all his
operations only by invoking the procedures.