3 Replies Latest reply: Sep 18, 2014 9:13 PM by WASIL

JDBC query return XMLType for ORACLE

(mike123) Jul 2, 2008 12:27 AM

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.

1. Re: JDBC query return XMLType for ORACLE

(mike123) Jul 3, 2008 9:33 AM (in response to (mike123))

Can livecycle JDBC service handle XML return type? Is there any work-around.
Thanks.
Like Show 0 Likes (0)

Actions
2. Re: JDBC query return XMLType for ORACLE

ChromeAdobe Sep 10, 2014 6:31 AM (in response to (mike123))

Is anyone having issues with XMLType Data type in Oracle 11.2.0.4 version using Micromedia JDBC driver? We are facing issue after upgrading Oracle DB to 11.2.0.4 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
Like Show 0 Likes (0)

Actions
3. Re: JDBC query return XMLType for ORACLE

WASIL Sep 18, 2014 9:13 PM (in response to (mike123))

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.

-Wasil
Like Show 0 Likes (0)

Actions

Go to original post