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?
Can livecycle JDBC service handle XML return type? Is there any work-around.
Is anyone having issues with XMLType Data type in Oracle 18.104.22.168 version using Micromedia JDBC driver? We are facing issue after upgrading Oracle DB to 22.214.171.124 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