Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

JDBC query return XMLType for ORACLE

Avatar

02-07-2008

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.

Replies

Avatar

03-07-2008

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

Thanks.

Avatar

Avatar
Level 1
ChromeAdobe
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
ChromeAdobe
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
ChromeAdobe
Level 1

10-09-2014

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


Avatar

Avatar
Boost 50
Employee
WASIL
Employee

Likes

50 likes

Total Posts

386 posts

Correct Reply

51 solutions
Top badges earned
Boost 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Boost 50
Employee
WASIL
Employee

Likes

50 likes

Total Posts

386 posts

Correct Reply

51 solutions
Top badges earned
Boost 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
WASIL
Employee

18-09-2014

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