Hi,

In creating an Oracle ORAdata-based object, I need to set its CLOB field from information obtained from a Hibernate persisted object (also stored on the same Oracle 10g database). However, trying to case a java.sql.Clob returned by a detached object from Hibernate to a CLOB results in a ClassCastException. According to this doc (http://www.hibernate.org/56.html), this should be possible. The Clob in the Hibernate object is definitely greater than 4000 bytes in size.

I need the Oracle ORAdata object to set as the payload for an Advanced Queue AQMessage.

Ideas? Suggestions?