" This problem is a mix of Java and Oracle. We have a TYPE OBJECT created in an Oracle 10g database for creating Excel documents. It has been in use and works well when called by other procedures within that Oracle database. We are trying to create an instance of it in Java. I created a simple test setup that worked, using the oracle.sql.STRUCT and oracle.sql.StructDescriptor classes. Iw as able to call procedures and methods and verify the results. Unfortunately I can't seem to get any success with the TYPE OBJECT that we need to manipulate. The Java code runs without generating any errors, but it appears that the TYPE OBJECT constructor (in Oracle) is never called, which of course makes it all rather useless. Has anyone had any dealings with a STRUCT? I'm at a loss here, having tried everything I can think of. I'm begging for help."

Okay, I don't know if it's bad for to reply to one's own post, but I
finally had some success this morning with this and wanted to share the
results (in case anyone else can make use of it).
As stated, the Oracle gurus created a TYPE OBJECT in the Oracle 10g
database (called EXCEL_DOC_TYPE). On the Java side I created the
oracle.sql.StructDescriptor and oracle.sql.STRUCT objects, the latter
being the Java object 'pointer' to the EXCE_DOC_TYPE. The end result
was to get a CLOB (Character Large Object) back from the database
containing the XML data to display an Excel worksheet in a browser.
I used an OracleCallableStatement to call the function within Oracle and
have it return the CLOB. Only problem was the CLOB only seemed to
contain the first 40 characters of the XML file. It looked like this:

This problem is a mix of Java and Oracle.
We have a TYPE OBJECT created in an Oracle 10g database for creating
Excel documents. It has been in use and works well when called by other
procedures within that Oracle database.
We are trying to create an instance of it in Java. I created a simple
test setup that worked, using the oracle.sql.STRUCT and
oracle.sql.StructDescriptor classes. Iw as able to call procedures and
methods and verify the results.
Unfortunately I can't seem to get any success with the TYPE OBJECT that
we need to manipulate. The Java code runs without generating any errors,
but it appears that the TYPE OBJECT constructor (in Oracle) is never
called, which of course makes it all rather useless.
Has anyone had any dealings with a STRUCT? I'm at a loss here, having
tried everything I can think of. I'm begging for help.