Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

JDBC query return XMLType for ORACLE


Former Community Member
I use JDBC service 'Query for Multiple Rows as XML' to query an Oracle database. One of the return field is of XMLType. The service return result as 'oracle.sql.OPAQUE@785a785a'. How can I access the return result?

Thank you.
3 Replies


Former Community Member
Can livecycle JDBC service handle XML return type? Is there any work-around.



Level 1

Is anyone having issues with XMLType Data type in Oracle version using Micromedia JDBC driver? We are facing issue after upgrading Oracle DB to and your application uses Micromedia JDBC driver?

We are getting following error:

[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments


Employee Advisor

You should stick to the data types provided by workbench(jdbc specific). The XMLType is specific to Oracle. Check out the mapping : Data Type and Java-to-Java Type Mappings

In this case try String or Blob.