This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes can´t read the Oracle´s XMLTYPE generated in a query in my JSP page Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "can´t read the Oracle´s XMLTYPE generated in a query in my JSP page" Watch "can´t read the Oracle´s XMLTYPE generated in a query in my JSP page" New topic
Author

can´t read the Oracle´s XMLTYPE generated in a query in my JSP page

antonio alvarez
Greenhorn

Joined: Aug 05, 2011
Posts: 1
Hi, I´ve been working on an application that return an XMLTYPE from an schema package, the XML is generated in a query, not read it in a table, and use that variable in a JSP.

The DDL of the package function is this:



as far as I see there shouldn´t be any problems with this stored function

The problem is on the JSP code

this is my code:



I´m getting te error:

SQL Error: java.sql.SQLException: Inconsistent java and sql object types: SYS.XMLTYPE

Making a debbuging I identified that the exception is been raised in this line:




I´ve been checking a lot of online documentation but I´ve not been able to make it work

If anyone could help me please, I don´t know what else to do

Thanks... sorry for the english
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Can you try this one

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: can´t read the Oracle´s XMLTYPE generated in a query in my JSP page
 
Similar Threads
Error java.sql.SQLException: Bigger type length than Maximum
sql exception : user property is missing ???
How to execute an scalar query ?
Selecting Data from Oracle
format xml data for output